Microsoft Access 2013 Inside Out

Debugging data macros with the Trace table

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 for the first time. You might even be wondering whether Access is even executing your data macros at all if you see no visible results. In Chapter 24, “Understanding Visual Basic fundamentals,” which can be downloaded from the book’s catalog page, you’ll learn that you have several tools available in the Visual Basic Editor for debugging Visual Basic code in desktop databases. Data macros, unfortunately, do not have as rich a set of tools available for debugging purposes. For example, you cannot set breakpoints on data macro logic to halt execution. ...