General discussion

Locked

How to List Access Tables in ComboBox

By Scott Horvath ·
I need to create a ComboBox that lists all of the tables in the Access 2000 database that I'm using so a user and pick a specific table to run a report for.
I know it can be done but I can't find the code I "borrowed" before to do this.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

How to List Access Tables in ComboBox

by Peyison In reply to How to List Access Tables ...

This should return all tables (not linked tables):

Select Name From MSysObjects
Where Type=1 And Flags=0

If you want to include linked tables, try:

Select Name From MSysObjects
Where (Type=1 And Flags=0) or (Type=6)

Hope this helps.

Collapse -

How to List Access Tables in ComboBox

by Scott Horvath In reply to How to List Access Tables ...

Great answer thanks!

Collapse -

How to List Access Tables in ComboBox

by donq In reply to How to List Access Tables ...

Peyison's answer is wright-on. Why don't you approve it and award him the points?

Collapse -

How to List Access Tables in ComboBox

by Scott Horvath In reply to How to List Access Tables ...

I was out of town so get over yourself and right the write words.

Collapse -

How to List Access Tables in ComboBox

by Scott Horvath In reply to How to List Access Tables ...

This question was closed by the author

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums