combo box to display query names

[tfoulkes]

Hi all,

I'm wanting to use a combobox to select a query from the queries which are available.

After this I'm going to pass it as a variable on a form for a select statement. This bit I'm fine with, It's just getting the dropdown of all available queries, not the values which that query returns.

Thankyou!

Tim

 

[jgoodman00]

To get a list of queries you need to run the following sql:

SELECT Name from MSysObjects WHERE Type = 5



James Goodman MCSE, MCDBA

http://www.angelfire.com/sports/f1pictures

 

[tfoulkes]

thats brilliant,
Ta

 

[tfoulkes]

How about to select the tables...
e.g.
MSysObjects Where Type = "table"

TIA

Tim

 

[jgoodman00]

Nope, they are integer values. A table has a type value of 1.

If you just look in the MSysObjects table you can work most of them out (thats all I have done).

James Goodman MCSE, MCDBA

http://www.angelfire.com/sports/f1pictures