Okay. Hi.
I'm a complete newbie to Access, I can just about figure that I want to use VBA coding to do this, however.
Essentially, I have a database of usernames and passwords called 'tbl_User' which contains there 'UserLogin' and 'Password' fields. I want to create a Login Form which contains two textboxes, one for the user to enter their 'UserLogin' and their 'Password.
If the user has left one or more fields blank, I want nothing to happen apart from a message popping up explaining they need to fill all details in.
If both boxes are filled out, I want the database to check that the username is listed in the database, under the 'UserLogin' section which contains all usernames. If it isn't message, if it is, it then checks the password to see if it is the matching one. If not, message etc, if yes, login access granted.
(( On a separate note, is there an easy way for a user to add a new employee to the User table, with an autogenerated username (which will be the first letter of their first name, and then there last name, and then '01' or '02' if there's already 01, etc.., and an autogenerated password that will be able for them to change on their first login? ))
I'm a complete newbie to Access, I can just about figure that I want to use VBA coding to do this, however.
Essentially, I have a database of usernames and passwords called 'tbl_User' which contains there 'UserLogin' and 'Password' fields. I want to create a Login Form which contains two textboxes, one for the user to enter their 'UserLogin' and their 'Password.
If the user has left one or more fields blank, I want nothing to happen apart from a message popping up explaining they need to fill all details in.
If both boxes are filled out, I want the database to check that the username is listed in the database, under the 'UserLogin' section which contains all usernames. If it isn't message, if it is, it then checks the password to see if it is the matching one. If not, message etc, if yes, login access granted.
(( On a separate note, is there an easy way for a user to add a new employee to the User table, with an autogenerated username (which will be the first letter of their first name, and then there last name, and then '01' or '02' if there's already 01, etc.., and an autogenerated password that will be able for them to change on their first login? ))
