Discussion Locked
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
You can generate a query based on text entered in a form.
Check out MS KB article Q235359 for extended information(http://support.microsoft.com/support/kb/articles/Q235/3/59.ASP)
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?
by mr_joey
This Worked - Thanks for your help!
by mr_joey
This question was closed by the author
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending
1 helpful
3 replies
Discussion Locked
What Makes a Business Website Effective in 2026
2 helpful
10 replies
Question
Windows and macOS computers becoming slow or unstable after updates - what should I check first
0 helpful
1 reply
Question Unanswered
Best Way to Make Long WordPress Location Guides Mobile Friendly
0 helpful
0 replies
Discussion
Optimizing WordPress widgets and DOM size
0 helpful
3 replies