Hi everyone...I created a table with the following data...
First Name : Last Name : User Name : Password. I then created a form called "Log In" which has two textboxes, one for the user to enter their User Name, and the other one to enter their Password. There are a couple things I"m trying to accomplish but I am not advanced enough in access to fully understand how to accomplish them. First thing is I want the user to enter their user name and password, and then when they click "Submit" access checks the table to see if their user name exists, and if it does it then checks to make sure their password is correct. If the user name does not exist or the password is incorrect I would like it to shoot out a msgbox saying the user name or password is incorrect. Secondly, I would like users to be able to change their passwords if their logged in (i am going to create another form for changing passwords) If anyone has any tips/code that would be much appreciated... Thank you
First Name : Last Name : User Name : Password. I then created a form called "Log In" which has two textboxes, one for the user to enter their User Name, and the other one to enter their Password. There are a couple things I"m trying to accomplish but I am not advanced enough in access to fully understand how to accomplish them. First thing is I want the user to enter their user name and password, and then when they click "Submit" access checks the table to see if their user name exists, and if it does it then checks to make sure their password is correct. If the user name does not exist or the password is incorrect I would like it to shoot out a msgbox saying the user name or password is incorrect. Secondly, I would like users to be able to change their passwords if their logged in (i am going to create another form for changing passwords) If anyone has any tips/code that would be much appreciated... Thank you