Keyword search engine???

[guitarfunk24]

I am trying to make a search engine form for one table of mine
because it has long descriptions for each record and there are 5000
records its kind of hard to use a combo box search. I was wondering
if anyone out there had an example of a keyword search engine so I
could see how to do it because I am at a loss. I already had a
criteria search engine that didn't work well enough for what I need.
I need something that will search out everything that has the word I
type in it and bring it up even if there are more words in the record.

 

[jahoobob via AccessMonster.com]

Try Allen Browne's method here:
http://allenbrowne.com/ser-62.html

 

[Marshall Barton]

I am trying to make a search engine form for one table of mine
because it has long descriptions for each record and there are 5000
records its kind of hard to use a combo box search. I was wondering
if anyone out there had an example of a keyword search engine so I
could see how to do it because I am at a loss. I already had a
criteria search engine that didn't work well enough for what I need.
I need something that will search out everything that has the word I
type in it and bring it up even if there are more words in the record.

Just use a an unbounf text box in a form's header section to
enter the word you want to look for. Set the form's record
source to a query for the records you want to search and use
this kind of criteria for the description:

Like "*" & Forms!theform.thetextbox "*"