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 - 20 Jun 2007 16:16 GMT
Try Allen Browne's method here:
http://allenbrowne.com/ser-62.html
>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
[quoted text clipped - 4 lines]
>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.
Marshall Barton - 20 Jun 2007 16:18 GMT
>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
[quoted text clipped - 4 lines]
>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 "*"

Signature
Marsh
MVP [MS Access]