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

[wsnyder3]

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

[pietlinden]

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.

[wsnyder3]

pi********@hotm ail.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.

[pietlinden]

ws******@mail.f scwv.edu wrote:

pi********@hotm ail.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 "