Getting a tables description

  • Thread starter Thread starter witharebelyell
  • Start date Start date
W

witharebelyell

Hi

In access 2000 + i noticed that you can add a table description by
right clicking on a table-> properties.

Q. Can you select this infomation from the access system catalogs (ie
sys* ) tables..

or can you only get this info from VBA. and how ..?

mike
 
Try:
Currentdb.TableDefs("MyTable").Properties("Description")

The expression will error if there is no description.
 
Hi

Is there a query or VBA way
to get the description property that is stored with a Macro or Report?
 
Hi

Is there a query or VBA way
to get the description property that is stored with a Macro or Report?
Click to expand...

Place this code in a module.

Public Sub GetDescriptionProperty()
' read the tag property of a report
Dim db As DAO.Database
Dim doc As Document
Set db = CurrentDb
Dim prp As Property
For Each doc In db.Containers("reports").Documents
For Each prp In doc.Properties
If prp.Name = "Description" Then
Debug.Print doc.Name & " " & prp.Name & " " & prp.Value
End If
Next prp
Next doc
End Sub
 
Back
Top