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
AutoExec Macro Ready
1. Once you are under the Macro object click
on the macro that you just created.
2. Click the Run command as shown in the screenshot above. This
will execute the AutoExec macro.
3. If you want to edit your AutoExec macro then click the Design
command after selecting the macro AutoExec.
Whenever you execute the AutoExec macro nothing will happen apparently
but each time MS Access will supply the credentials (login/password) to
Oracle Database Server. You can notice that by looking at the Network
Activity icon next to the time in your Window XP system.
The icon will blink as soon as you perform this run operation on
AutoExec macro.
If you have not supplied proper Oracle Database
user’s credential (login/password) while preparing the code for AutoExec()
function you will encounter an error.
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: