VBA Documentor code

[mckitlk]

Hello, everyone,

I was wondering if anyone knows where I can find VBA documentation /
analysis code that I can copy into an .mdb file?

I'm looking for something that will go through the entire database,
tracing where all the objects, functions, procedures, and variables
are used and which ones are unused. It's to help me clean up and
understand the workings of someone else's work.

It can't be a downloadable utility -- not even a free one -- because
my employer prohibits that sort of thing for security reasons.

Thanks so much!

Laura

 

[Tony Toews]

It can't be a downloadable utility -- not even a free one -- because
my employer prohibits that sort of thing for security reasons.

Sorry, no idea. I'd suggest changing employers but that's not always
an option.

If you need to build your own attempt to search Access help for form
and report control collections. Then you can review the forms and
reports record sources, analyse the fields on queries and then scan
through all the VBA code.

This could easily take a week for me to do and I'm very familiar with
the workings of Access. I also have built much the framework of this
processing in one fashion or another.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

 

[Pat Hartman]

Your employer's attitude is inexplicable. I have created code to do some of what you're looking for and I used the tabledefs and querydefs collections but parsing code is significantly more difficult. I would estimate 20 hours to do only a very basic documenter. You can buy an excellent product called Total Access Analyzer from www.FMSINC.com for around $250. If 20 hours of your time is not worth $250, you're working for the wrong company.