MS Access 2003 Step By Step - Asim Abbasi
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Chapter 5: MS Access Modules & Macros
Creating Macro: AutoExec
1. In order to create a new macro first click
on the Macros object under the Objects group as shown in the slide
above.
2. Click the New command as shown in the slide. This will open up
the Macro window with the default name as Macro1.
3. All the functions that you created e.g. Modules will appear in
this section provided you have created one before.
4. All the macro actions will be visible in the drop down list.
From that list we have selected RunCode command option.
Each line on this window you can specify the Macro commands under the Action field. All the Macro commands will appear as soon as you will click the drop down menu. This has been shown in the picture below.
From this list select the RunCode command option. This has been shown as label 4 on the screenshot at the start of this article. Then select the function that we created earlier in the Module section of this chapter i.e. AutoExec() function.
Chapter 5: MS Access Modules & Macros
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Share with others: