Discussion Locked

"Search Engine" Within MS Access 97

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a way to Make a "search engine" or to have a user enter search criteria into a form that will search through the database? I can't find anything on Microsoft's site at all. I have about 1000 records in a database that all have a keyword andit would be nice to have the user be able to manually search through those with a "search engine" like form.

5 replies

by mr_joey

This Knowledge Base Article only works with Access 2000. I am running Access 97, and will not work.

by andrew

Couldn't you just provide a text box to accept space-delimited keywords, construct a query like:

SELECT * FROM Table1 WHERE Keyword IN ('k1','k2','k3')

Then display the results?

This discussion is closed to new replies.