Printing Code

[oskar]

How do I print the complete code of a project?

If I select all the code with CTRL+A in the code window does it print all the objects of the project I'm in or I have to select each object from the drop down list at the top of the code window?

 

[CJ_London]

uses the database documenter.

 

[oskar]

uses the database documenter.

Are you saying to use the database documenter? Where is this?
Thank you

 

[CJ_London]

Not sure where in 2003 and earlier (no longer have a copy) but in 2007 and later you will find it under the database tools tab

 

[oskar]

I got it CJ, I have Access 2010 and it is where you say, Thanks

But it does not provide for any code printing because in the Modules tab it shows nothing and no matter which tab I select it only makes one page document and its all about the properties.

I have printed the code from my project which is 2 pages but was wondering if it is the right way to print a code by selecting with Ctrl+A all the code in the View Code

 

[CJ_London]

Do you actually have modules? if you only have class modules relating to forms and reports, you will find it there.

So to answer theis question:

How do I print the complete code of a project?

Go through each of the tabs and click 'select all' then once all are clicked click on OK

If you are wanting to document your project this is what you should do, however if you only want the code

I

have printed the code from my project which is 2 pages but was wondering if it is the right way to print a code by selecting with Ctrl+A all the code in the View Code

Having selected with Ctrl+A you then need to paste it to the printer somehow. Ctrl+A will only select the code in the module you are in as I am sure you will have noticed

Alternatively in the VBA window select File>Print and choose your options.

 

[oskar]

Now I got it, my best option is then from the VBA window to select File/Print and then I choose
Thanks so much