[AccessD] "Find" combo box searches more than one table

Nicholson, Karen cyx5 at cdc.gov
Fri Aug 19 10:35:54 CDT 2005


Oooh.... I want to see it too!  I have over 1235 tables that I am
putting into one table but this code would be great in the meantime. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Klos, Susan
Sent: Friday, August 19, 2005 11:27 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] "Find" combo box searches more than one table

Yes, Kath, I think that is what I am looking for.  Can you send me a
copy of the code?

 

Susan Klos

Senior Database Analyst

Evaluation and Reporting

Florida Department of Education

850-245-0708 

sc 205-0708

 

Maybe Susan means that the users would like to have a 'search function'
which will find something anywhere in the database.
 
I have had that request before, eg. for a database that tracked travel
agent wholesalers, travel agent retailers, suppliers, clients etc. Users
would get an inquiry from someone and wanted to type in their name and
find all instances anywhere in the system.
 
It depends whether you need to populate a combo or not. In my case I
created an unbound text box and users type in any part of the person's
surname and hit enter.
 
The code then searches through the relevant tables one by one and
populates a results table.
 

Kath

 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list