How does the Quick Search feature work? (1 Viewer)

[MsLady]

I need to implement a Quick search feature in my employee application

so that when any text is typed into the textbox, it searches the db for a match:
e.g.
firstname
lastname
ss#
employeeId
deptId
officelocation
deptname

it returns the record in the employee table that consist of the text typed in the search box. Most websites have this quick search feature (blanket search..is that what it's called?) and a link for advanced search, where they can select specific fields to search.

What does the query performing this blanket search look like? Please enlighten

 

[mhartman]

Hello:

http://www.utterangel.com/pages/access_downloads.aspx

Candace's "Flexible Query" might be what your after.

Regards
Mark

 

[mhartman]

Hello:

Here's another link that tells how to build your own.

http://support.microsoft.com/kb/235359/en-us

Regards
Mark

 

[mhartman]

Hello:

The above link is for an Access project. Below would be for an Access database

http://support.microsoft.com/kb/210242/en-us

Regards
Mark

 

[MsLady]

Hello:

http://www.utterangel.com/pages/access_downloads.aspx

Candace's "Flexible Query" might be what your after.

Regards
Mark

Thanks mhartman!
The Flexible Query will definately come in handy when i do to do the "Advanced search" in this application.

I am particularly looking into the "Quick Search one textbox keyword feature" where you just type in any value (e.g. lastname, firstname, ss#, department) and it does a blanket search in all the fields and pulls up matches?

Someone told me something about the full-text catalog query in sqlserver (since im using sqlserver) not sure how that works.