How to get list of Tables in Current open database?

Y

Yogesh

I want list of 'all tables' available in current database in to one list box
/ combo box.
 
A

Allen Browne

Yogesh said:
I want list of 'all tables' available in current database in to one list
box
/ combo box.
Click to expand...

Try setting the combo's RowSource like this:

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (MSysObjects.Type In (1,4,6)) AND Not
((MSysObjects.Name Like "MSys*") Or (MSysObjects.Name Like "~*"))
ORDER BY MSysObjects.Type, MSysObjects.Name;
 
Top