467,118 Members | 994 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Share your developer knowledge by writing an article on Bytes.

Debugging in VBA

NeoPa
Expert Mod 16PB
VBA executes whenever the code is triggered from within your project.
This can be from all sorts of object events from simply opening a form to clicking on a command button.
When something doesn't work as expected, how can you determine exactly what is wrong and where?

Well, that's what this article can help you with.

With every Office application, including Access of course, there is an integrated debugger. To open the window of the debugger and to give you access to all the code associated with your project (There is one project with every database), simply press Alt-F11. This will also switch you between associated Debugger and Application windows when you're currently in either.
  1. Overview.
  2. The Various Panes.
    1. The Code Pane (F7).
    2. The Project Explorer Pane (Ctrl-R).
    3. The Properties Pane (F4).
    4. The Immediate Pane (Ctrl-G).
    5. The Object Browser Pane (F2).
    6. The Locals Pane.
    7. The Watch Pane.
  3. General Tips.
May 18 '07 #1
  • viewed: 15449
Share:

Sign in to post your reply or Sign up for a free account.

Similar topics

16 posts views Thread by Serdar Kalaycý | last post: by
2 posts views Thread by Andy Fish | last post: by
2 posts views Thread by Alex Clark | last post: by
5 posts views Thread by Velvet | last post: by
6 posts views Thread by KevinGPO | last post: by
5 posts views Thread by =?Utf-8?B?Z2FkeWE=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.