By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,505 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Search all tables for a field and then display all account if found

P: n/a
I am trying to create a search where the user can type in a word and if
there are any matching word(s) on any table that it will display the
tables matches. I am not real familiar with Access I am still
learning. If anyone has any ideas of how to accomplish this it would
be greatly appreciated.

Thank you

-D

Jun 5 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
if you want to search more than one or two fields for the same word(s),
then your database structure sounds a bit suspect. Why would you have
the same type of data in more than one field in your table? Could you
give a scenario illustrating what you are trying to implement? Perhaps
your design is less than ideal.

Jun 6 '06 #2

P: n/a

pi********@hotmail.com wrote:
if you want to search more than one or two fields for the same word(s),
then your database structure sounds a bit suspect. Why would you have
the same type of data in more than one field in your table? Could you
give a scenario illustrating what you are trying to implement? Perhaps
your design is less than ideal.


Yes my design wasn't quite right but I fixed it. When I meant search
forms I meant be able to find like key words. My fields contain long
sentences such as "Problem/Resolutions" so when people want to refer
back to these or for an easy look up they could just type in a keyword
and all the fields that have that word would come up.

Jun 23 '06 #3

P: n/a

ws******@mail.fscwv.edu wrote:
pi********@hotmail.com wrote:
if you want to search more than one or two fields for the same word(s),
then your database structure sounds a bit suspect. Why would you have
the same type of data in more than one field in your table? Could you
give a scenario illustrating what you are trying to implement? Perhaps
your design is less than ideal.


Yes my design wasn't quite right but I fixed it. When I meant search
forms I meant be able to find like key words. My fields contain long
sentences such as "Problem/Resolutions" so when people want to refer
back to these or for an easy look up they could just type in a keyword
and all the fields that have that word would come up.


create a query...

SELECT {FieldList}
FROM {SomeTable}
WHERE {SomeField} LIKE "*" & Forms![MyForm]![txtTextbox] &"*"

and a form.... add a textbox called txtTextbox
and then save the form.

Modify the SQL to point at whatever form you like (it must be open for
this to work.)
You could create a button that runs the query.

DoCmd.OpenQuery "qryMyQuery"

Jun 24 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.