question

[karl]

I am relatively new at access 2000 and i was wondering how
can i populate a list box of all the objects in a
database?

thank you in advance

 

[Guest]

Hi Karl
I will try to help but please explain what you mean by populate and all
objects?
Ed

 

[John Vinson]

I am relatively new at access 2000 and i was wondering how
can i populate a list box of all the objects in a
database?

thank you in advance

This would be a rather odd thing to do, but... create a Query

SELECT MSYSObjects.[Name] FROM [MSYSObjects] ORDER BY [Name];

and use it as the rowsource of your listbox. This will include a
number of system objects whose names begin with MSYS... or ~sq...
which you might want to omit using query criteria; take a look also at
the other fields in MSysObjects if you're interested. (Use Tools...
Options... General and check the System Objects checkbox to see this
table).

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps