VIEWING THE ORDER OF PROCEDURE CALLS

Another necessary debugging tool that Access provides is the capability to view procedure calls. You can get to the Calls dialog through a couple of different routes, but this section focuses on the Immediate window.

One reason for viewing the procedure calls is that sometimes you need to verify how a routine was called. This is especially true if you have more than one way to get into a routine.

To view the procedure call stack from the VBE, follow these steps:

1.
Open the GlobalUtilities module.
2.
Go to the ap_AppInit() function.
3.
Place a Stop statement in the first line of code following the function declaration. Then close the module.
4.
Execute the function by running the AutoExec macro. When ...

Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.