By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,486 Members | 1,660 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,486 IT Pros & Developers. It's quick & easy.

Access macro listing/catalog

P: 34
Is there a way of producing a printout of an Access macro (or all macros in the database) using VBA, ideally one line per command for documentation purposes?

Many thanks for any help.
Apr 21 '09 #1
Share this Question
Share on Google+
5 Replies

Expert Mod 15k+
P: 31,709
Have a look at the Documenter feature.

Tools / Analyse / Documenter

This should give you everything you need without needing to resort to programming anything.
Apr 21 '09 #2

P: 34
Thanks, but when using that option, it produces a listing with approx. 4 entries per page, and not very readable at that.
Apr 21 '09 #3

Expert Mod 15k+
P: 31,709
Can you attach an example. You can produce it in RTF for opening in Word, but either format will do to look at.

My recollection is that there are a whole bunch of options available. It may just be a case of choosing the right ones.
Apr 21 '09 #4

P: 34
I've uploaded a .txt file, becauseof size restrictions here. I've also had to remove a lot of the spacing in between the entries. The entries represent one pageful which is produced - I only wanted the coding bits, i.e. commands, operands, parameters, etc.

I've found coding previously which allowed access to queries (QueryDef/qdf, etc.) so I'm hoping to find something similar for macros.
Attached Files
File Type: txt doc_rptObjects.txt (780 Bytes, 308 views)
Apr 24 '09 #5

Expert Mod 15k+
P: 31,709
If the documenter is not good for you, then we should have a look at what's available in code.

CodeProject.AllMacros & CurrentProject.AllMacros both give access to the name and certain basic properties. Neither seems to have the attributes you would require (the design of the macro itself). If I find anything else I'll post.
Apr 24 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.