refer to an access tables properties

  • Thread starter Thread starter DavidSherwood
  • Start date Start date
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.
 
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

Determine Module Type 2
Hiding Built-in Access tables 4
reference application object of mdb opened with OpenDatabase 16
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
A list of allowable DAO user-defined properties 8
Trying to convert an AccessObject to a Form 3
Code to find table dependencies of queries 10
VB access to tables collection 1

Back
Top