Anyone,
I am using a log in form on my database. Along with the credentials, the employee table has a true/false box that defines if the user's password needs to be reset. The default value of this is true (so that when a new employee is added, the logon will require their password is changed). I have the LogOn form working perfectly. It sends the proper users (those who are marked as requiring a password reset by a true value in the employees table) to the password reset form. Here's my question: what is the VBA code I need that forces 1). the value in EmpPassword in the table "Employees" to be overwritten with the value entered in "txtNewEmpPassw ordConfirm" and 2). changes the value of the true/false box in table "Employees" to false?
(I have already written the code that ensures the two entries of the new password match. If they do not, they are given a prompt explaining that and the focus is sent back to the first text box.)
Thank you for your help!
I am using a log in form on my database. Along with the credentials, the employee table has a true/false box that defines if the user's password needs to be reset. The default value of this is true (so that when a new employee is added, the logon will require their password is changed). I have the LogOn form working perfectly. It sends the proper users (those who are marked as requiring a password reset by a true value in the employees table) to the password reset form. Here's my question: what is the VBA code I need that forces 1). the value in EmpPassword in the table "Employees" to be overwritten with the value entered in "txtNewEmpPassw ordConfirm" and 2). changes the value of the true/false box in table "Employees" to false?
(I have already written the code that ensures the two entries of the new password match. If they do not, they are given a prompt explaining that and the focus is sent back to the first text box.)
Thank you for your help!
Comment