Is it possible to search access fields by keyword?

M

MNLoriB

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!!!
 
R

Rick B

Sure. Just make the criteria for that field something like this...


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

MNLoriB

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...
 
M

MNLoriB

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
 
Top