MACROS - Read source of - OpenQuery OpenReport OpenForm

[dpimental]

Is there a way to read the list of macros and read through their source to see if there are commands to see if there is a OpenQuery, OpenReport, OpenForm command and then see what the arguments are for them?

I can get the list of macros from the MSysObjects table.

SELECT MSysObjects.Name, MSysObjects.Type, MSysObjects.Id
FROM MSysObjects
WHERE (((MSysObjects.Type)=-32766))
ORDER BY MSysObjects.Name;

I can't see to find where the source is located?

There is not a container "object" in the containers of the database for Macros.

I can't seem to find where they are?

Are they compiled once you save them?

Are they in one of the microsoft system database?

David Pimental
(US, Oh)

 

[PHV]

Have a look here:

http://mdbdoc.sourceforge.net/

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[RoyVidar]

You may also fin faq705-5796 of some use.

Roy-Vidar