refer to an access tables properties

D

DavidSherwood

How do you refer to a table's property sheet values? I thought they would be
in the AccessObject's Properties collection, but the tables haven't any.
 
A

Allen Browne

Use DAO code to loop through the Properties of the TableDef.

You may also want to loop through the Properties of each Field in the
TableDef.

If this sounds new, see the TableInfo() example here:
http://allenbrowne.com/func-06.html
It shows how to loop through the fields, and read the Description property
for each one.
 

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

List all tables, including document structure 0
Help creating a search form in Access XP 0
Hiding Built-in Access tables 4
reference application object of mdb opened with OpenDatabase 16
A list of allowable DAO user-defined properties 8
VB Script reference cells for in current table? 1
Linking data in MS Word into Excel 5
Trying to convert an AccessObject to a Form 3

Top