Debugging Data Macros

You’re likely to encounter unexpected errors or unintended results when you’re designing data macros attached to table events and complex named data macros attached to tables for the first time. You might even be wondering if Access is even executing your data macros at all if you see no visible results. In Chapter 24, you’ll learn that you have several tools available in the Visual Basic Editor for debugging Visual Basic code. Data macros, unfortunately, do not have a rich set of tools available for debugging purposes. You cannot, for example, set breakpoints on data macro logic to halt execution. You also cannot single-step through the macro logic as you can with user interface macros.

The best tools you have for debugging ...

Get Microsoft® Access® 2010 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.