How to create a pop-up search field

R

reeve13

I have an extremely large database which is in a continuous form format
and what I would like to happen is, instead of using the find butto
that would just find a word, I would like to have a pop-up search bo
that would yield actual texts throughout the DB (something like th
search feature in Adobe Acrobat). In addition, I would like to use th
"and" or "plus" together to search for additional data if needed
Please, unless there is a sample I could download and use in my db
please be specific in your instructions since I am new to all this.

Thanks!
 
A

Arvin Meyer [MVP]

You can't really search a database that way. Each search works on one field
at a time. You can write code that will iterate through fields in a table
and check their datatype, then do a search if the datatype is correct. You
could possible iterate through tables as well. Or you could use a form and
predefine which fields and table you wish to search in by checking off
values. In no case will it be like searching Adobe Acrobat which only
searches a single document. That would be similar to searching a single
value in a single record in a memo field.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top