listing the syntax of macro and a query

[Morris]

Hi! I've got about 10 macros in the access database they gave me and
each macro mainly runs queries. Now I'm thinking is that a way to
display each line of the macro (the value of "Action" and "Comment"
fields) and the Name and SQL view of each query listed in Queries
object?

thanks a lot
Morris

 

[Guest]

Hi,
you could try to use the build in Documenter (Tools--Analyze...). If it is
not extensive enough then look around for some third party add-ins. A good
free one would be Jeff's CSD Tools:
http://home.bendbroadband.com/conradsystems/accessjunkie/csdtools.html
HTH
Good luck

 

[Morris]

Hi,
you could try to use the build in Documenter (Tools--Analyze...).

That's extensive enough, thanks very much!