M
misschanda via AccessMonster.com
Is there a way to Create a Search function that searches every table in the
entire database?
Thanks
LA
entire database?
Thanks
LA
misschanda via AccessMonster.com said:From your advise earlier:
search parameter in a text box on a form. Then in the criteria
of the appropriate fields in the queries, put something like below that calls
on the text box.
[Forms]![frmParameter]![txtParameter]
You could also put a button on the form to run code or a macro which will
open all the queries.
My objective was acheived. However, ran into problems when trying to search
phrases or joining two different words to search as in Blue and Polymer. I
was hoping to figure out a way to create a system that when search criteria
is entered into the text, the criteria can search phrases and etc.
Jerry said:No easy way. You'd have to write some code to go through the table and column
collections.
The important point is that you should not need to IF the database tables
are properly set up (i.e. normalized). If you have something like seperate
tables for June, July, August, etc., data, that is the problem. All the same
data should be in one table.