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 Module: auto_login
1. Once you have your MS Access up and running
click on the Modules object under the Objects group.
2. As shown in the slide above, click ‘New’ to create a new
module.
3. Another window will popup with the tile MS Visual Basic. Click
on the Name property as shown in the slide above and name it as ‘auto_login’.
4. This is the place on the screenshot shown above where you will
see ‘MS Visual Basic’ as title.
The target over here is to create a Module so that we don’t have to
login to Oracle Server every time we open MS Access. We have just named
that module as ‘auto_login’. Next step would be to populate this module
with program logic.
Once you double click the module ‘auto_login’ as shown below. This will
open the code window for auto_login module.
Populate the code area with the code shown in the next screenshot. Like I said before this book is not meant for, to make you master on MS Visual Basic programming but those who know Visual Basic understand very well what we want to do via this code. We will do explain this code in detail in the next article.
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: