Saving and Printing VB Code

[MSAccessRookie]

I am finishing up a conversion project (MS Access2003 Stand-Alone that was already split and users already had their own FE with a shared network BE, to an MS Access2003 using SQL Server 2005 for its BE.

I am in the process of VB Code Cleanup and Documentation. There is a Module called "MicroSoft Office Access Class Objects" containing Private Code that is Related to over 50 Forms, and a number of additional Modules that contain Pubic Code in the form of Common Functions and Subs. I would like to save and print these, but I have not found a way other than doing it one Object at a time.

Is there a better way?

 

[ajetrumpet]

is it possible I wonder to loop through each module, select the text, and SAVEAS a new file? Or save it however you are doing it? Use the "modules" collection...

 

[boblarson]

I am finishing up a conversion project (MS Access2003 Stand-Alone that was already split and users already had their own FE with a shared network BE, to an MS Access2003 using SQL Server 2005 for its BE.

I am in the process of VB Code Cleanup and Documentation. There is a Module called "MicroSoft Office Access Class Objects" containing Private Code that is Related to over 50 Forms, and a number of additional Modules that contain Pubic Code in the form of Common Functions and Subs. I would like to save and print these, but I have not found a way other than doing it one Object at a time.

Is there a better way?

See if this helps:
http://mdbdoc.sourceforge.net/

 

[ajetrumpet]

that's interesting Bob. What research...

 

[MSAccessRookie]

See if this helps:
http://mdbdoc.sourceforge.net/

Great idea, It looks like this could work, except that I do not have the ability to install any new software add-ons here.

 

[MSAccessRookie]

is it possible I wonder to loop through each module, select the text, and SAVEAS a new file? Or save it however you are doing it? Use the "modules" collection...

This sounds like an idea worth exploring. Is there a way to identify the VB Code on an item by item basis?

 

[Pat Hartman]

The built in database documentor prints code. Its formatting leaves a little to be desired but you can export the file to word and modify it if you want to.

 

[MSAccessRookie]

The built in database documentor prints code. Its formatting leaves a little to be desired but you can export the file to word and modify it if you want to.

You are right that it is not very pretty, but it will be a good start toward the perceived end

 

[MSAccessRookie]

The built in database documentor prints code. Its formatting leaves a little to be desired but you can export the file to word and modify it if you want to.

You are right that it is not very pretty, but it should be a very good start toward the perceived end