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
Save & Exit Macro Design View
1. Finally click the save button and name your
macro as AutoExec. Any macro having the name AutoExec in MS Access will
get executed automatically as soon as MS Access gets alive or in other
words when you double click MS Access icon on you desktop.
2. Close out the MS Access database window.
After closing out the MS Access environment, turn it back on. You will
see that MS Access will no more ask you for the login/password stuff.
Why? Because as soon as MS Access gets alive it looks for the macro with
the name AutoExec, if it finds then it executes that macro. In our
AutoExec macro we have coded to run AutoExec() function. This function
is the one we created in the earlier part of this chapter and it in fact
contains the login/password information as well as script to logon to
Oracle Server.
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: