Code to list macro contents

  • Thread starter Thread starter Freddy G
  • Start date Start date
F

Freddy G

Is it possible to create a loop that would cycle through
each macro object in my database and list each action
inside the macro? For instance, write the macro's name to
a field in a temp table and then write each action for
that particular macro sequentially in a memo field.

I have about 90 macros that print different combinations
of access reports and when I have to switch out reports
from the macros it becomes quite a pain going through each
macro and checking if the report I am looking for is in it.

Thanks in advance
 
"It sounds like Tools|Analyze|Documenter will give you
what you want."

is there any way to format the report? the design option
for the report is disabled so i assume i can't, because
when i select to analyze only the "actions and arguments"
option of the 90 macros it creates a 256 page report
because of so much wasted paper space. flipping through
256 pages looking for a specific report is almost as bad
as manually going into design mode of each macro to look.
i was hoping there was a rotine i could create to get the
macro actions into a table to be able to then run a query
to find which macros had the reports i would be looking
for.

Thanks again
 
Back
Top