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

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

http://www.fmsinc.om

--
M. Shipp


"Brian" wrote:

> 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
>

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....



--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)