Search options (Page 5 of 101)

Hi,
The name of the grid is 'frmdbcoreusers.gridusers'
However, I can't find any reference to the name of the 'role' combobox on 'frmdbcoreuserform'.  I wrote a small program a while back to identify all the elements on the 'frmdbcore' suite of forms and the one element that it never found was the 'role' combobox which is puzzling.
Derek.

Hi Step-In,
Probably a few ways to do it.
Attached is one suggestion using a calculated field;  I've used a second tablegrid to load the consolidated (one line per driver) data before running the report rather than hijack tablegrid1 (I didn't want to mess up your layouts etc).
Select a driver using the existing combobox (combobox2) or leave the combobox blank to see all drivers.
You'll probably want to alter the layout of the concatenated field and also the report so I didn't spend any time on them - it's more just to give an idea how you could approach it.
Regards,
Derek.

Hi,
Try it like this (see attached). 
I'm guessing that there are probably two ways you might want to see the selected rows in the memo fields (one per line or comma delimited) so both options are in the script.
Regards,
Derek.

Hi,
I thought that the example I sent earlier already did this.
When you have loaded your .csv file, you can click on the 'view import' button and any parts that do not exist are highlighted with a 'not found' warning.
You can simply place a button on the 'frmviewimport' form to create a new record if required.
Derek.

Hi,
Perhaps you could try it something like this (see attached).
On Form1, you can
1.  manually adjust quantities by selecting a part number from the combobox, typing in an adjustment amount and the qty is updated.
2.  update adjustments in batch by uploading a CSV file.  Specifically,
2.1  click on the 'import' button to load the CSV into the 'csvimport' table.
2.2  click on the 'view import' button to review what is going to be updated - it will also show any data mismatches.
2.3  click on the '⇈' button to update the quantities in the 'tameio' table.
Maybe this gives you some ideas.
If anything is not clear, just shout.
Regards,
Derek.

Hi,
I'm not entirely sure what you are wanting to do.
Perhaps you can give us some more details (ideally with an example of what should happen).
Also, I don't understand how you want Excel to work with your program.
Regards,
Derek.

Привет Godless, Vladimir,
Если я правильно понял вопрос, чтобы удалить пустые строки в таблицах, вы можете создать два статических фильтра (по одному для каждой таблицы).
Смотрите скриншот во вложении.
С уважением,
Derek.
.
If I understood the question correctly, to remove empty rows in the tablegrids, you can create two static filters (one for each tablegrid).

Hi StateOne,
Another slightly different approach is to use overlaid labels.
The attachment is based on elapsed time but it could just as easily be applied to any scenario such as your 'diesel tanks' example.
Maybe this gives you some more ideas.
Regards,
Derek.

Hello All,
There is also an option to make the combobox non-searchable (no need for a script  - see the attachment (and the screen capture in the attachment)).
This fixes the problem of the combobox taking a long time to retrieve the relevant data - however, although you can still SORT the combobox, you lose the functionality of being able to SEARCH the combobox and this may be too much of a compromise.
Acknowledgement to Sparrow for the test program and data.
Derek.

Hi,
I guess it's the difference between 'search' and 'filter' (without getting weighed down in semantics ).
When I use an editcounter (which doesn't allow 'fuzzy' searching), I'm not actually using it to search for a record that I can't find - I already know the number - I'm using it to filter out all the other rows in the tablegrid that I don't want and go directly to the record rather than always scrolling up and down;  in a tablegrid with a large number of rows, it's probably the fastest way of doing it.
Typically, I use an editcounter to auto-generated invoice or order numbers.
Of course, you can always copy an editcounter into a calculated field which would allow 'fuzzy' searching if that's more applicable;  as always, it depends on the actual requirement.
Derek.

Привет,
Попробуйте так (хотя есть и другие способы).
Если вы используете общую процедуру (в примере она называется «buildlabel»), это означает, что одна и та же процедура запускается, если вы щелкаете по сетке с помощью мыши, если вы используете клавиатуру для прокрутки, а также когда вы закрываете Form2.
С уважением,
Derek.

Hi Thierry, Konstantin,

The field that stores a link to the table should be called id_<table name>

Manually adding a field to the table and calling it 'id_[tablename]' to force a relationship back to itself is very neat - and so simple (but then, everything is simple once someone first thinks of it and shows you how!).
I've added this to my list of useful tricks.
Thanks,
Derek.