Easier Searching for Records?

[Guest]

I have created a Music Library database. Is there anyway to create an
"easier" search method other than using a query. I want someone who doesn't
know how to use Access to be able to find a song or particular artist without
having to type: like "*artistname*" in the query box everytime they want to
find something. Thank you.

 

[Guest]

Try this

Select TableName.* From TableName Where FieldName Like "*" & [Please enter
artists name:] & "*"
This query will prompt the user to enter artist name, and it will search for
any name that this string apear in it

 

[Jeff Boyce]

What level of experience/comfort do you have in developing in MS Access?
The short answer is 'yes'... (but "simple" ... is hard!).

Consider using a form with combo boxes listing artists and pieces, then
dynamically building a SQL statement to return all entries matching the
search criteria selected (rather than entered).

Regards

Jeff Boyce
<Office/Access MVP>

 

[Guest]

PERFECT! you saved me a bunch of trouble. thx

Try this

Select TableName.* From TableName Where FieldName Like "*" & [Please enter
artists name:] & "*"
This query will prompt the user to enter artist name, and it will search for
any name that this string apear in it
--
I hope that helped
Good luck

I have created a Music Library database. Is there anyway to create an
"easier" search method other than using a query. I want someone who doesn't
know how to use Access to be able to find a song or particular artist without
having to type: like "*artistname*" in the query box everytime they want to
find something. Thank you.