asked on

Print VBA code nicely formatted from Access 2010

I'm sure this has been asked before. Is there an easy way to print all my vba code from my Access (2010) app? I know there are reporting tools to buy but I'm at a site where I can not download nor get approval to buy any. I would think after all these years Microsoft would have fixed that issue.

Any suggestions would be helpful. As for the apps to download or purchase I will also like to know for future use. but for now I need to do it without buying or downloading any apps.
Does anyone have any code that will do this?

Thanks

ASKER CERTIFIED SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Scott McDaniel (EE MVE )

There's the Documenter, which will create a report that you can print. It includes statistics and such, of course, but it also includes the actual code.

Other than that, you can use the undocumented SaveAsText feature. See this EE question for more information about that:

https://www.experts-exchange.com/questions/28450832/SaveAsText-all-forms-or-objects.html

I would think after all these years Microsoft would have fixed that issue.

I wouldn't call this an "issue". In 15 years I can think of only a handful of times I've needed to print any code at all.

Chuck Lowe

ASKER

Thanks. It serves it's purpose. I'd really like the functions and modules etc do be separated like it displays in the vb window with a line but this is good enough.

Thanks again.