Listings of Objects

[Bob Brodbeck]

Does anyone know a way to get a simple listing of objects
in an Access DB? For instance, I'd like to be able to
produce a simple listing, without properties, of the names
of the queries in a DB. Unfortunately the Documenter puts
each query on a separate page.

Thanks!

 

[Fredg]

Bob,
In a Combo Box RowSource (or as a separate Query):

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

 

[Bob Brodbeck]

Fred --- Thanks much! This is great. Looks like Type 6
are the Tables. Oh how I spent too much time trying to
find in Access where I could do this simple thing.

Thanks again === Bob

-----Original Message-----
Bob,
In a Combo Box RowSource (or as a separate Query):

SELECT MSysObjects.Name FROM MSysObjects WHERE (((Left

((MSysObjects.Type)=5)) ORDER BY MSysObjects.Name;

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.

Does anyone know a way to get a simple listing of objects
in an Access DB? For instance, I'd like to be able to
produce a simple listing, without properties, of the names
of the queries in a DB. Unfortunately the Documenter puts
each query on a separate page.

Thanks!

.