J
Jean-Francois Gauthier
Hello, I am working on a database that I would like to have the following
functionality. I am a fairly basic user at Access and VBA programming and am
therefore looking for help to either find an already made login application
in Access that I can use and only tweak the code to match my tables and
fields, or if possible to have someone help me with how to code my program.
Using Access 2000
I have the following:
Tables: "tblUsers", "tblContact" (for email), and "tblEmployee"
tblUsers contains the following fields: "Emp#", "UserID", "Password" and
"UserType"
tblContact contains the following fields: "Emp#", "Email", "Phone"
tblEmployee contains the following fields: "Emp#", "EmpFN", "EmpLN
I have a form called "frmLogin"
The user needs to input his UserID and Password and click on the button "Log
in". I want the program to check the UserID and Password entered vs what is
in the "Users" table. If there is a match, the employee is taken to the
"frmSwitchboard" form where he/she has different options to choose from. If
there is no match, employee is asked to try again. If after 3 tries there is
no match, then the database is closed. I want to have a msg box come up to
say "User ID or Password is invalid, please retry." After 3 times, before
database closes, I want a msg box that says "Access Denied. Please contact
your administrator.".
The user also has the option to choose another button that is below the "Log
In" button that is "Forgot Password?". When the user clicks on this button,
the program will then check the "tblUsers" table for the "UserID" and with
the Emp# field, match this to the "Emp#" field in the "tblContact" table, and
will retrieve the users Email adress from the "Email" field in this table.
A secondary program would then email the user his User ID and password. The
email title would be "Access Reminder" and would contain the password.
Is this possible?
functionality. I am a fairly basic user at Access and VBA programming and am
therefore looking for help to either find an already made login application
in Access that I can use and only tweak the code to match my tables and
fields, or if possible to have someone help me with how to code my program.
Using Access 2000
I have the following:
Tables: "tblUsers", "tblContact" (for email), and "tblEmployee"
tblUsers contains the following fields: "Emp#", "UserID", "Password" and
"UserType"
tblContact contains the following fields: "Emp#", "Email", "Phone"
tblEmployee contains the following fields: "Emp#", "EmpFN", "EmpLN
I have a form called "frmLogin"
The user needs to input his UserID and Password and click on the button "Log
in". I want the program to check the UserID and Password entered vs what is
in the "Users" table. If there is a match, the employee is taken to the
"frmSwitchboard" form where he/she has different options to choose from. If
there is no match, employee is asked to try again. If after 3 tries there is
no match, then the database is closed. I want to have a msg box come up to
say "User ID or Password is invalid, please retry." After 3 times, before
database closes, I want a msg box that says "Access Denied. Please contact
your administrator.".
The user also has the option to choose another button that is below the "Log
In" button that is "Forgot Password?". When the user clicks on this button,
the program will then check the "tblUsers" table for the "UserID" and with
the Emp# field, match this to the "Emp#" field in the "tblContact" table, and
will retrieve the users Email adress from the "Email" field in this table.
A secondary program would then email the user his User ID and password. The
email title would be "Access Reminder" and would contain the password.
Is this possible?