How to get Macro and Reports description?

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

witharebelyell

Hi

Is there a query or VBA way
to get the description property that is stored with a Macro or Report?
 
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
 
Is there a query or VBA way
to get the description property that is stored with a Macro or Report?
Click to expand...

VBA way:

CurrentDb.Containers("Reports").Documents("myreport").Properties!Description

Use Scripts container for macros.
 
Back
Top