How to get list of Tables in Current open database?

  • Thread starter Thread starter Yogesh
  • Start date Start date
Y

Yogesh

I want list of 'all tables' available in current database in to one list box
/ combo box.
 
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;
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing combo box box that's not an option in its drop-down list 5
Limit Combo Box records in Table/form 6
Combo box in multiple tables within a database 4
Record-Locking remains open after closing 0
run query from 2 tables where value is null in 1 of the tables 4
Question ref look up table 0
Drop-down list that only shows relevant reports 3
Using Combo Boxes as filter criteria 16

Back
Top