This is a modified version of a Universal Search originally written by Candace Tripp. The original expected a numeric PK in the first field. I have modified it to have the PK in any position, BUT it must be a single field Primary Key. You are presented with a form into which you enter comma separated strings. The search is made against all text fields of data type text in all nonSystem tables.
see attached OpeningForm ModifiedUniversalSearch.jpg
Enter some sample keywords, or parts,separated by commas see Sample search terms.jpg
Click Search and see results Sample Output from Search.jpg
Double click one of the search results to open a detail form with some fields (first 11 IIRC) from the record in the table
see DoubleClick on a term opens Detail Form.jpg
The database was obtained from UtterAccess and modified by me as mentioned above. My changes were made in 2010, and the database was saved in 2003 mdb format.
I have put in a few validation lines, trapped a couple of errors, and added a basic timer. It came with some sample data, and I have have linked a few of my own. Delete the linked tables and link to your own.
Good luck !!!