F. Scott Barker’s Microsoft Access 2002 Power Programming

Appendix A. Debugging Code in Access 2002

IN THIS APPENDIX

• Setting the Correct Module Options for Maximum Debugging Power 2

• Using the Immediate Window 6

• Stopping Program Execution 10

• Debugging One Step at a Time 12

• Viewing the Order of Procedure Calls 14

• Watching Expressions During Program Execution 15

• Controlling Code with Conditional Compilation Commands 22

While creating an application, you can spend much time and effort trying to figure out those bugs that creep into the system. These bugs can greatly slow down the completion of the application.

This appendix discusses the Access 2002 tools that handle bugs and examine code while creating an application. Mainly because of the Visual Basic Editor (VBE), debugging changed in Access 2000 from previous ...