table names

[Duckman]

How do I set up a combo box to contain the names of all the tables of the database?

 

[Atomic Shrimp]

if you open up the Tools/Options dialog, in the View tab, there is an option 'System objects' - check this.
then some new objects will appear in your tables tab, one of them is called 'MySysObjects' - if you open this, it's actually a lot like a table (you can use it in a query and that query as the row source for your combo, but it can't be updated) if you select all of the rows where 'Flags' = 0 and 'type' = 1 then you should end up with a list of your table names in 'name'.

I'm sure there must be an easier way than this though...

Mike

[This message has been edited by Mike Gurman (edited 02-19-2001).]

 

[skiphooper]

Hi,
I have recently created a small app in A2k.
Part of it, is probably what you are looking
for. There are two combo boxes on the form.
The first box is filled with all the tables
names in the database. when you click on the
table name you want the second combo box
fills with that tables field names.
If this is what you are looking for, let me
know and I'll E-mail them to you.
Remember, this is in A2k. I can convert it to A97 if need be.

HTH
Skip


[This message has been edited by skiphooper (edited 02-19-2001).]

 

[Jack Cowley]

This is from Dev Ashish's web site...

SELECT MSysObjects.Name FROM MSysObjects WHERE (Left$([Name],1)<>"~") AND (Left$([Name],4)<>"Msys") AND (MSysObjects.Type) = 1 ORDER BY MSysObjects.Name;

Put this as the Row Source of your combo box and you should be good to go....