Total Visual CodeTools

Total Visual CodeTools manual

Microsoft Office Access 2016, 2013, 2010 Version
is Shipping

New Verrsion

Supports Office/Access 2016, 2013, 2010, 2007, 2003, 2002, 2000, and Visual Basic 6.0!

Also available for
Access 97


View all FMS products for Microsoft AccessAll Our Microsoft Access Products

CodeTools Info:

Why CodeTools?

 

"Total Visual CodeTools is by far my favorite third-party product."

Alison Balter, Author, Conference Speaker, Instructor

More Reviews

Additional Info:

 

 

Create, Maintain, and Deliver better Microsoft Access, Office, VBA and VB6 code with Total Visual CodeToolsTotal Visual CodeTools for Microsoft Access, Office, VBA, and VB6Coding Tools for Microsoft Access, Office, VBA, and VB6 Free trial of Total Visual CodeTools for Microsoft Access, Office, VB6 and VBA

Shortcut Keys for Debugging in VBA, Microsoft Access and Visual Basic 6

Provided by: Luke Chung, President of FMS, Inc.

Microsoft Access, VBA, and Visual Basic 6 developers are blessed by a powerful Integrated Development Environment (IDE) with powerful debugging tools. Learning its features will help you code better and faster, and simplify applications testing and maintenance.

View Menu in the IDE

In addition to being able to change your code (within reason) while in the debugger, you have the immediate window, locals window, watch window, call stack and other resources under the View menu to help you debug and understand what your code is doing. Make sure you learn what these windows can do for you.

Module IDE View Menu in VBA and VB6

Shortcut Keys for Debugging

As you examine your code line-by-line, here are some shortcut keystrokes every VBA/VB6 developer should use within the IDE:

Keystroke Keystroke Description
Shift-F2 Definition: Put the cursor on the variable, procedure, or property in question and press [Shift-F2] to see where itís defined. Youíll jump directly to it. You can do this as often as you like to understand how your code works.
Ctrl-Shift-F2 Go back to where you came when you pressed [Shift F2]
F9 Set (or reset) a breakpoint to stop the program when it gets to this line
F5 Run the current procedure (if it doesnít require parameters)
F8 Run the current line
Shift-F8 Step over the line by running the procedure on the current line without going into it and stepping through each line
Ctrl-Shift-F8 Run through the rest of the current procedure (useful if you no longer need to examine the procedure)
Ctrl-F9 Set the next statement (jump over existing code)

For more tips on debugging, read our whiter paper on Microsoft Access VBA/VB6 Debugging Tips and Techniques.