• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 13. Creating Macros > Testing a Macro

Testing a Macro

Although Access doesn't offer very sophisticated tools for testing and debugging macros, it does give you a method for stepping through each line of a macro:

1.
Open the macro in Design view.

2.
Click Single Step on the toolbar or select Run | Single Step.

3.
To execute the macro, click Run. Access executes the first line of the macro, and the Macro Single Step dialog box appears, showing the macro name, condition, action name, and arguments (see Figure 13.18). In the figure, the macro name is mcrPersonalInfo, the condition evaluates to True, and the action name is MsgBox. The MsgBox arguments are You Are Over a Quarter Century Old, Yes, and Information.

Figure 13.18. Viewing the macro name, condition, action name, and arguments for the current step of a macro.


4.
To continue stepping through the macro, click the Step button on the Macro Single Step dialog box. If you want to halt the execution of the macro without proceeding, click the Halt button. To continue normal execution of the macro without stepping, click the Continue button.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint