PC Review

Thread Tools Rate Thread

Re: Search Tables

Bob Barrows
Posts: n/a
      23rd May 2010
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

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating archive tables for Access tables joined to Sybase tables =?Utf-8?B?QXJjaGl2ZSBUYWJsZXM=?= Microsoft Access External Data 0 11th Jan 2006 11:31 PM
cannot remove search assistant - my search/my quick search bar =?Utf-8?B?Y2hyaXMgYm9uZHk=?= Windows XP Help 1 2nd Apr 2005 05:54 AM
search assistant-my search/my qucik search bar =?Utf-8?B?Y2hyaXMgYm9uZHk=?= Windows XP Help 2 1st Apr 2005 03:07 PM
Tables, Tables, Tables - FP 2003 =?Utf-8?B?QmV2ZXJseS1UZXhhcw==?= Microsoft Frontpage 6 3rd Feb 2005 01:05 PM
Text Search: how to search a substring using search companion Search Question Windows XP General 2 23rd Mar 2004 04:28 PM




All times are GMT +1. The time now is 05:09 AM.