We have a MS Access 2003 DB with 27 tables, 2 queries, 49 forms and 79 reports.

Most of the forms and reports have a lot of VB code attached to them.

I know how to print the code for each and every form/report but now I need to make changes across the entire DB and need a full print-out of all code in the DB.

Is there any way (I can't find any!) to instruct the DB to print ALL code recorded?

Printing all code for each and every form/report is a lot of work which I don't fancy, being as lazy as I am.

The print-out will be in the range of 150-200 pages which is no problem using an old dot-matrix printer with continuous paper.

opalhort

Hi opalhort.

This might be something for you:

http://www.demtron.com/blog/post/2008/09/2...-Generator.aspx

It works for me.

Thank you very much srs

This should do the trick. Will give it a try this weekend.

Though was hoping there may be a hidden 'click-click' solution inside Access but obviously the M$ guys can't think that far.

Thanks again

opalhort

I don't know of any built-in solution which is strange since it would be easy for Microsoft with all their manpower to implement that.

Must be some company policy related reason

Good luck