Printing VBA Code

[Guest]

Does anyone know how to print (or save to file) all of the VBA code in a
single Microsoft Access. I know I can print all code from each individual
object, but with 105 forms and 75 reports plus all the modules, I figure
there has to be an easier way!

Thanks!
Brian

 

[Guest]

There's a great tool that I use daily. It's called Total Access Analyzer.
Check out the website

http://www.fmsinc.om

 

[Albert D. Kallal]

You can print all of the forms code, eve the sql used, or whatever..

Use the database documenter...

tools->analyzes_>documenter.


Note that you can even have the document print out all of your table "field
names" and even have it display in a NICE formatted columnar listing for
your field names (just remember to play with the "options" settings before
you start printing, and test it with just a FEW things selected - if you
don't do this, you are likely to print a ream (that is 500 sheets) of pager
before you even blinked....


Anyway, the documenter should sufficed for your needs....