O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

DEBUGGING ONE STEP AT A TIME

To work through some debugging situations, you need to be able walk a program line by line while it's executing. VBA provides four Step commands to accomplish this: Step Into, Step Over, Step Out, and Run to Cursor. You can use these commands after a program halts execution by choosing the appropriate command from the Debug menu.

Note

All four step commands skip over the same type lines of code that don't allow breakpoints: comments, declaring variables (the Dim statement), blank lines, and line labels or line numbers.

Stepping into Code Line by Line

The Step Into command steps through code lines one by one. When a code line has a call to another procedure, the editor then follows the code into it. This includes ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required