ek
|
| Posted: 05/22/2002, 5:26 PM |
|
In MSAccess, one can open a table and do a search on all fields. There is also an option to "match any part of field". When I create a search using CodeCharge, how do I tell it to search all fields in the table using the option to "match any part of field". Thanks ....
|
|
|
 |
Sixto
|
| Posted: 05/22/2002, 11:46 PM |
|
There are 2 ways you can achieve this:
A. With the wizard, select an OR search and add every field.
B. By hand
1. Add a single field to the search form, and change its name to something other than the field's name (eg. username -> s_username )
2. In the grid form, open form properties and select input. Add as many parameters as you have fields. Name every one of them the same as the parameter name of the search form (eg s_username), then associate each parameter with each field in your table and set the operation to be Like '%..%'. This, of course, only works for text fields. For numeric fields select any other operation option.
To better understand how this all work, you should let the wizard create a test grid form with an OR search, study its configuration, and try to recreate the whole thing by hand.
Regards,
Sixto
|
|
|
|
ek
|
| Posted: 05/24/2002, 1:17 PM |
|
Thanks Sixto ... suggestion "A" works for me ....
ek
|
|
|
|
Molly
|
| Posted: 09/03/2002, 2:51 PM |
|
Suggestion B works fine if you don't want to search on any other fields from the table. I just need to concat three fields to search on then use the other fields in the table for other search criteria. Is there any way to do this?
|
|
|
|
|
