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.

Related Module and Procedure Reports

• Module Analysis Summary (across all documented forms, reports, and standard modules)
• Single Module Overview
• Procedure Lists
  • Sorted by Module and Procedure
  • Sorted by Procedure Order
  • Sorted by Procedure Name (Procedure Dictionary)
• Procedure Usage
  • Procedure Calls - What each Procedure Calls
  • Procedure Usage - Where Procedures are Called From
  • Procedure Usage - Non-Event Procedures only