How to use Tabledef to get list of tables in acce

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
How to use Tabledef to get list of tables in acce

Access VBA Discuss using VBA for Access programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

March 23rd, 2005, 08:35 AM

method

method is offline

Friend of Wrox

Join Date: Mar 2005

Posts: 264

Thanks: 0

Thanked 0 Times in 0 Posts

Default

How to use Tabledef to get list of tables in acce

I wonder how in VB6, i can use Tabledef to get the list of tables in an access database and display it in a combo box. I be hapy if some one show me how. thanks

Old

March 23rd, 2005, 02:08 PM

BrianWren

BrianWren is offline

Friend of Wrox

Join Date: Nov 2004

Posts: 1,621

Thanks: 1

Thanked 3 Times in 3 Posts

Default

Access Database objects have a TableDefs collection. You can iterate through that to get the names if the items in the collection. Using the results, add rows to the dropdown.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DAO TableDef eqivalent in ADO	dirtdog22	Access VBA	9	May 12th, 2010 11:44 AM
i have problem in index collection of tabledef	good man	Access	1	December 11th, 2006 08:41 PM
How do I get a list of all tables of Oracle DB?	amjad_mahmood	Excel VBA	0	August 5th, 2005 06:56 AM
Getting list of tables using DB name	shazia1	VS.NET 2002/2003	2	July 6th, 2005 12:17 PM
list all tables using SELECT Statement	rylemer	Access	5	March 7th, 2005 08:58 PM