Let the user pick the Table to access

[Ghost308]

I'm writing a real simple database editor for the data entry people here and I'd like to have a combo box list all available tables in a given Database (these are MS Jet .mdb files from MS Access). I think I'm just missing a simple property here, if anyone knows a quick way to do this I'd greatly apreciate it!!!

[Cakkie]

I assume you have a database object called db that points to the database. The database has a propertie tabledefs, which is a collection of all tables in the database.

dim TD as TableDef

for Each TD in DB.TableDefs
List1.AddItem TD.Name
next TD




Tom Cannaerts
[email protected]

Programming today is a race between software engineers striving to build bigger and better idot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook