'Search Database' using keywords

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone,

I want to create a search database that uses keywords to search for info in
the database. I have created one long time ago...but I lost my database when
I lost my external hard drive. I am a beginer when it comes to Access, and
when I created my previous search database it was a combination of sample
work that I downloaded from the Internet. I could not find the links to those
sample work anymore. A link to this kind of database or a sample database
will be much appreciated.
 
Aggy,
Use the tools Access gives you...
Create a form to display your data, and use the right-click menu "Filter by Form" to
locate records in your table that meet any criteria you might want.
 
Al Camp,

Oh I am not trying to search for forms...I want to create a 'Google-like'
search database, where I can type in a word or phrase on a search box and
then it'll give me results of Info that has the keywords on their fields.
Thanks for the input anyway. If you know how to do this or if you know a link
to a sample database please let me know. Thanks!
 
What do you mean, "it'll give me results of Info that has the keywords
on their fields"?

Al's method will search the table, for records in which, a specified
field contains, the text that you entered.

For example, it could search the table for records in which the XYZ
field contains the phrase, "now is the time".

Is that what you want? If not - what?

HTH,
TC (MVP Access)
http://tc2.atspace.com
 
That's what my solution is... Filter By Form is a way to apply criteria/s against all
the records in a table to find those that match that criteria.

Read Access Help on "Filter By Form"
 
Back
Top