question

K

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
 
E

Ed

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

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
Click to expand...

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
 
Top