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

Hiding Built-in Access tables 4
Refer to a form instance 3
A list of allowable DAO user-defined properties 8
Built in properties not found 2
enumerating tables collection or fields in ADOX blows up Access 4
Allforms Collection in another db (A2007) 4
calling objects method 4
Reading SQL Server Extended Properties 0

Top