Search options (Page 84 of 104)

Hi Adam and Happy New Year to one and all,
If you want to insert the cell contents (text, symbols - anything) from a tablegrid rather than a combobox, I'd do it this way (see attached) but as always, there may be other options;  I've attached it to a cell_click event rather than a button (it's one click less) - LOL!
Regards,
Derek

Hi Adam,
I'm struggling to see why you would want to interactively change the font, size, colours etc - maybe someone else could have a look at it (but after a quick glance of the code, it seems that you are now wanting to load 2 different font settings but you only have 1 'savefont' procedure, so both grid and memo will always take the font settings of whatever was last saved).
With regard to the other points, attached is the way that I use to add text either at the end of a memo or part way through it (either by using the mouse or positioning with the keyboard).  It's only a couple of lines of code so it's probably the simplest (which is why I use it - LOL!) but there may be other (better?) ways to do it.
My attachment demonstrates your 'dates' example, but the principle is exactly the same for inserting anything from whatever combobox drop downs you want to place on the form, so you just copy and paste the code as required.  I've used it quite a bit in apps for inserting names and addresses, part numbers and descriptions - that sort of thing.
I've also done it 'on click' of the drop down rather than using a separate button - just seemed a bit neater - but you can put it back on a button if needed.
Regards,
Derek.

Hi 01xbruno,
The syntax of what you are trying to do looks fine.  What event are you associating with altering the colours for the column headers?
In the attached example, I'm using the form1_tablegrid1_onchange event, and it seems to be working as you want.
Regards,
Derek.

Hi Lectrond,
Any field that is defined as 'text' should appear, by default, as left justified (and with a left justified heading) in any tablegrid.  For this, you wouldn't need to write any script.
If you could attach your first test database (without the .exe file) where the text was appearing as right justified, I'm sure someone would be able to have a look at it for you and see if something isn't set up correctly.
Also, which version of MVD are you using?
Regards,
Derek.

Hi Adam, Mathias,
Update on my last post.
Attached is a new version that (I think) gets round the problem of the incorrect record being highlighted when the sorted field is changed.
So, in summary,
1. a saved (inserted) row is highlighted when you go back to the grid.
2. an amended row is correctly highlighted when you go back to the grid (even if the sort order has been changed).
3. a deleted row moves the cursor to the next row in the grid.
Hope this helps and you can follow what the script is doing - pretty messy and there are probably more efficient ways to do it.
Regards,
Derek.

Edit:  just noticed a line of code that shouldn't have been there - taken out and re-uploaded 23.12.2017 @ 17.31 GMT.  Sorry about that

Hi Adam,
I spent a few minutes trying different approaches but there's no way you'll ever get it to be a 'true' tree structure with multiple levels, visual indenting of sub-records etc. 
It would be a nice feature to have but there are plenty of things with the existing basic tablegrid that I think could be improved upon first.
Anyway, if you play around with some of the grid settings you can at least make it look okay and showing a hierarchy of tablegrids (in this example, to 3 levels) has never been much of a problem.
Derek.

Hi Nyzari,
I don't think the problem is due to your filters.
In form wndwspecies / tablegrid1, you are calling a field called individual.outdated that doesn't exist any more.  Looking at your tables, I wonder if you renamed it to individual.archived at some point?  If you make changes to field names, you need to remember to go through and update any old references.
Attached is the fixed project.
Regards,
Derek.

Hi,
It might be if you've included the .exe in the zip folder.  Try deleting the .exe, zip it again and try uploading once more.
Derek.

Hi Again Adam, EHW,
Your last attachment (devbookmark enhanced3) reminded me of something I wrote from a while back that might be of interest;  the requirement was to 'make it like a spreadsheet' - LOL! 
Like you, I wanted to use the editable tgrid but, for me, it had (and still has) too many issues to be usable - it would have been nice to see some of them addressed with the release of Version 4. 
So I approached it from a different angle by using a normal grid, reducing the size of the column headers to 0, placing edit fields on top of where the column headers would normally go and then scripting (not too much!) so it behaves a bit more like an editable grid.
Maybe this helps in your discussions.
Derek.

Hi Nyzari,
If I understand your question correctly, the syntax you need is 'boolean field = 0 ' or boolean field = 1 to return filtered values of 'No' or 'Yes'.
Have a look at the attachment (part of an old project) and see how the grids are filtered on 2 boolean fields.
Hope this helps
Derek.

Hi Kees,
Is this more what you are after?  (see attached)
Regards,
Derek.

Hi Adam,
If you're interested in saving space on forms, a couple of alternative approaches (in the attachment) that I've used in the past might help.
Option 1 - keyboard short-cut (ALT+M) to toggle a menu off and on
Option 2 - use a 'bounce bar' - just take the mouse right to the bottom of the screen to display a menu (very much like the windows taskbar).
And the other option (not included in the attachment) would be to add items to the mouse 'right click'.
Obviously, you can do this with pretty much anything (although both examples I have attached just happen to be for menu options).
I'm sure any of the above can be used in conjunction with Dmitry's solution.
Regards,
Derek.