If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Search Tables
My client would like to have 6 or so combos on a form, in which they can
query any field from any table, and export the results to excel. yikes. i figured the first combo, i can do a list of available tables (tests). then when they select a test, the combos will list all available fields within that table. any idea on a systemic way to accomplish this without manually typing in everything to a table? thanks John -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1 |
#2
|
|||
|
|||
Search Tables
Sigh ... Show them how to use the Query Builder and be done with it. Why try
and reinvent the wheel? Are these large tables? Will you be providing a way for the users to supply criteria? Will you be allowing them to join tables? That said, you can use the Fields collection of a Tabledef object to populate the fields combo. If you need details, you should post in the VBA DAO group - it's really out of scope of this newsgroup. PS. You might try searching www.rogersaccesslibrary.com or Allen Browne's site - there may be a ready-made demo for what you are trying to do. auujxa2 via AccessMonster.com wrote: My client would like to have 6 or so combos on a form, in which they can query any field from any table, and export the results to excel. yikes. i figured the first combo, i can do a list of available tables (tests). then when they select a test, the combos will list all available fields within that table. any idea on a systemic way to accomplish this without manually typing in everything to a table? thanks John -- Microsoft MVP - ASP/ASP.NET - 2004-2007 Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM" |
#3
|
|||
|
|||
Search Tables
I agree with Bob. Teach them to use that and then show them how to use
TransferSpreadsheet. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1 |
#4
|
|||
|
|||
Search Tables
Look here - this will do it:
http://www.rogersaccesslibrary.com/f...12&OB=ASC.html Look for: DH (DuaneHookom) QBF. Regards Kevin "auujxa2 via AccessMonster.com" u37567@uwe wrote in message news:a872bfd25d6ab@uwe... My client would like to have 6 or so combos on a form, in which they can query any field from any table, and export the results to excel. yikes. i figured the first combo, i can do a list of available tables (tests). then when they select a test, the combos will list all available fields within that table. any idea on a systemic way to accomplish this without manually typing in everything to a table? thanks John -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1 |
Thread Tools | |
Display Modes | |
|
|