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
auto_login Visual Basic Code
The auto_login code is nothing but a single function named AutoExec(). The function begins with the keyword ‘Function’ and ends with ‘End Function’ as shown in the screenshot above as well as below.
.
.
.
If any module contains the AutoExec function, it will
be the first thing that will get executed within the module upon
execution.
To use variables and objects in your code you first have to define them.
That’s the reason we have defined ‘db’ as a object variable and
‘strConnect’ as String variable at the beginning of function code.
In case if the error happens while the execution of the code, we want to have the message to be popped up to the user. To do this we have written a error capturing code as shown below.
If the error occurs while the execution of the code,
the microprocessor will jump to AutoExec_Err subroutine. In this
subroutine we have a command of ‘MsgBox’ which is used to pop up message
box. After the user will click <OK> on the popped up message box, the
code execution will end as we have ‘Resume AutoExec_Exit’ command in the
next line. When the microprocessor encounters this command, it jumps to
the ‘AutoExec_Exit’ subroutine. Underneath this subroutine we have the
command of ‘Exit Function’ which results in termination of the code
execution.
If you are new to Visual Basic then there is no need to mess with this
code. All you need to do is to change the Username and Password section
of the code as supplied by Oracle Database Administrator and the DSN you
created earlier in this book i.e. ‘ODBC Link to Oracle Server’. As shown
in the code line below the username is ‘system and password is ‘takveendb’.
strConnect = "DSN=ODBC Link to Oracle Server; SERVER=;UID=system; PWD=takveendb"
In the whole code you just have to replace the word ‘system’ with the
username you have to login to Oracle Database Server and ‘takveendb’
with the password for the same account. Once done, then upon the
execution of the module MS Access will use this account (login/password)
to do the data manipulation as per your command, inside Oracle tables,
provided the Oracle user account has sufficient privileges.
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: