Databases Reference
In-Depth Information
Figure 9-1. The Add Procedure dialog box
9.4 Run Mode, Break Mode, and Design Mode
The VBA IDE can be in any one of three modes:
run mode
,
break mode
, or
design mode
.
When the IDE is in design mode, we can write code.
Run mode occurs when a procedure is running. To run (or execute) a procedure, just
place the cursor anywhere within the procedure code, and hit the F5 key (or select
Run
from the
Run
menu). If for some reason a running procedure seems to be hanging, we can
usually stop the procedure by hitting Ctrl+Break (hold down the Control key and hit the
Break key).
Break mode is entered when a running procedure stops because of either an error in the
code or a deliberate act on our part (described a bit later). In particular, if an error occurs,
Access will stop execution and display an error dialog box, an example of which is
shown in Figure 9-2.
Figure 9-2. An error message
Error dialog boxes offer a few options: end the procedure, get help (such as it may be)
with the problem, or enter break mode to debug the code. In the latter case, Access will
