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.

Microsoft Access Module Summary report

Related Module and Procedure Reports

Free Product Catalog from FMS