Can I setup a search engine?

[Scott]

How do I create a search engine of some kind for my database? (without having to setup a new query everytime)


I have a database which contains a library of topics and related notes associated with books, movies, internet, etc.
What I want to be able to do is search the database TOPICS field through some type of search engine to find all the resources that cover a particular Topic in my database and where they can be found.

For example, if I want to find all the resources I have assoicated with TREES, I want to either be able to type in the word "trees" or maybe even use a drop down list and select trees and a page comes up with all the resouces associated with trees.

Thanks for any help or suggestion.

Scott

 

[John Vinson]

For example, if I want to find all the resources I have assoicated with TREES, I want to either be able to type in the word "trees" or maybe even use a drop down list and select trees and a page comes up with all the resouces associated with trees.

A Parameter Query is just the ticket for this kind of thing.

I'd suggest that you create an unbound Form, frmCrit, with a combo box
cboSearchTerm listing the choices. Create a Query with a criterion on
the (memo? text? I don't know where TREES would be stored in your
table) of

LIKE "*" & Forms!frmCrit!cboSearchTerm & "*"

Base a second form on this Query and put a command button on frmCrit
to launch the second form.