Code Documenter for VBA

Quick Jump

Download

Download

This database has CascadeDelete on. To delete previous results, delete records in dc_Files then Compact/Repair. Back it up before CR if you have results you want to keep.

CodeDocumenter_s4p_vba7peter__ACCDB.zip (1 mb, unzips to an Access ACCDB database file.)

License

This database may be used freely, but you may not sell it in whole or in part. You may include it in applications you develop for others provided you keep attribution, mark your modifications, and share this source link.

Remember to UNBLOCK files you download to remove the Mark of the Web. Here are steps to do that: https://msaccessgurus.com/MOTW_Unblock.htm

Back Story

I wrote the code documenter many years ago, learning from others; most notable who contributed are Chip Pearson, Wayne Phillips, Allen Browne, Terry Kreft, Pat Wood, Bill Mosca, Adrian Bell, and Peter Cole ... some silently by sharing publicly.

Adrian wrote the code to open an Access database programmatically and bypass the startup stuff.

Additionally, before a database (or any file) is opened, the Read-Only flag is set to True and when closed, it's flipped to False. If you break the code and don't run again on the same file, you may need to change the file attributes yourself (right-click on file in Windows explorer, choose Properties, and uncheck the Read-Only box on bottom).

One of the beauties of Access is that it shares a common VBA backbone with other office applications. This makes communicating easy.

The Code Documenter can document code in any VBA project. You can expand the menu options since its open, modify the code, create your own queries, and whatever else you want.

In case you're wondering ... files being analyzed have read-only temporarily set so the date/time of file being documented won't get changed.

Thanks to Peter Cole for making this work in VBA7, which is available in Access 2010 and above. Download Peter's Scanner and Viewer to find problems and lookup correct syntax for API calls.
https://www.thememydatabase.co.uk/access32to64.html
it's free -- click the Download button and then click Add to Cart in the screen that pops up. There won't be a charge. Email address is only for Peter.

Peter's API Viewer tool gives you syntax for API declarations, types, and constants. You make the changes, but then you also may need to change called and calling variable data types. If you have a bunch of stuff, or a lot of databases, you can save a lot of frustration by getting his help.

Also in the Code Documenter is Wayne Phillips' brilliant File Property Viewer from EverythingAccess. I love this and have it pinned to my taskbar. Article and download: https://www.everythingaccess.com/tutorials.asp?ID=Accessing-detailed-file-information-provided-by-the-Operating-System

For a light analysis of lots of databases, mainly to see lists of objects, get ListObjects_LoopFiles ACCDB with source code.

For object and structure analysis of databases, get the free Access Analyzer ACCDB with source code and lots of tables you can query.

There are other documentation tools on MsAccessGurus that you might like such as documenting and formatting SQL in queries, row sources, and record sources: Document SQL, RecordSource, RowSource for Queries, Forms, and Reports.

Share with others

here's the link to copy:

https://msaccessgurus.com/tool/CodeDocumenter.htm

Training

Are you looking for one-on-one help?

Let's connect and team-develop to make your application a success. As needed, I'll pull in code and features from my vast libraries, cutting out lots of development time, and teach YOU how it is done. By combining your business knowledge and my development and teaching skills, your application will be more useful. You get the glory from your peers and I'm happy that you're putting Access to good use.

After you roll out, I'll help when you need me. History has shown that can be a week or a month to 5 years and longer. You learn how to modify and manage the application. I'll help when more complex things are needed.

Email me training@msAccessGurus.com ~ crystal