Microsoft Access Summary of All Modules in the Database

A great overview of each Microsoft Access module and class grouped by Object Type. See separate totals for form modules, report modules, and regular modules, plus a grand total for all your code. For each module, these summaries are provided:

• Number of lines
• Number of procedures
• Number of Declare statements (API references)
• Number of labels
• Number of procedure calls (calls invoking other procedures)
• Number of function calls (calls invoking VBA functions)
• Number of variables
• Number of conditional compiler directives
• Whether Option Explicit is set. If not, this is a potential source of bugs since variable definitions are not required.

This is a great guide if you're inheriting someone's database and need to determine the relative complexity among modules.

Additional Resources

• Summary List of Total Access Analyzer Reports
• Complete List of Total Access Analyzer Reports
• Best Practices for Microsoft Access Database Development