Is it possible to search access fields by keyword?

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

Guest

I have created some parameter queries to search by product or category, but I
am looking for a way to allow a remote user to search a large text field by
keyword/keywords. Is this possible? (I am not proficient in HTML or Visual
Basic, so if it needs to be done as code, I'd need a lot of help)!

Thank you to anyone that can point me in the right direction!!!
 
Sure. Just make the criteria for that field something like this...


Like "*" & [Enter word to find] & "*"
 
Rick,

Thanks much! This is a lot closer! I still have a question though...using
your criteria, it appears to only search for the first occurence of the
keyword. Is there a way to modify the criteria you provided to pull any
records within a given table or query with that word?

Have a great day!!!

Lori

Rick B said:
Sure. Just make the criteria for that field something like this...


Like "*" & [Enter word to find] & "*"


--
Rick B



MNLoriB said:
I have created some parameter queries to search by product or category, but I
am looking for a way to allow a remote user to search a large text field by
keyword/keywords. Is this possible? (I am not proficient in HTML or Visual
Basic, so if it needs to be done as code, I'd need a lot of help)!

Thank you to anyone that can point me in the right direction!!!
Click to expand...
Click to expand...
 
Rick,

(Amending my previous reply) the query is only searching the first record
for the keywords, which we changed to a memo field rather than text, as we
needed more characters. If I enter a word that is not in the first record,
it just pulls up a blank record...any thoughts?

Thanks again!

Lori
 
Back
Top