CHAPTER 27
Debugging Your Access Applications
Many Access applications rely on significant amounts of VBA code in forms and reports and as stand‐alone modules. Because of its power and flexibility, VBA is used for all aspects of application development, from communicating with the user to massaging and transforming data on its way from tables and queries to forms and reports.
Like with any programming language, debugging an error in VBA or a problem in an application can be difficult and time‐consuming. Depending on how well organized the code is and whether simple conventions, such as providing descriptive names for variables and procedures, were followed, tracking down even a small coding bug can be a frustrating experience.
Fortunately, Access provides a full complement...
