A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Search Tables



 
 
Thread Tools Display Modes
  #1  
Old May 23rd, 2010, 08:54 PM posted to microsoft.public.access.queries
auujxa2 via AccessMonster.com
external usenet poster
 
Posts: 118
Default 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  
Old May 23rd, 2010, 09:37 PM posted to microsoft.public.access.queries
Bob Barrows
external usenet poster
 
Posts: 475
Default 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  
Old May 23rd, 2010, 11:37 PM posted to microsoft.public.access.queries
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default 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  
Old May 23rd, 2010, 11:48 PM posted to microsoft.public.access.queries
Kc-Mass
external usenet poster
 
Posts: 362
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.