Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / June 2007

Tip: Looking for answers? Try searching our database.

Keyword search engine???

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
guitarfunk24@yahoo.com - 20 Jun 2007 14:59 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
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]

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.