create a "general search" function similar to the issues database

[Guest]

Hi. I have a database and I want to do be able to search the entire database
table by searching on any word. Basically, type a word in the field, click
"search" button and the results show at the bottom just like in the issues
database.

The way the search function is set up in the issues database is perfect.
How do you copy or tweek the code to work with any database?

 

[Al Camp]

Vannah,
I think you mean "search on any field" on the form?
Consider the built-in FilterByForm. Right click on any form, select FilterByForm, and
you can then enter single, or multiple, or ranges of values in any field or fields to
search for. It's ready-made, and particularly for single field criteria, very simple.
I really think it would be worth a look-see at that resource first, rather than try to
reinvent the wheel with a great deal of hand coding.