How to Create Re-Set password for Admin: MS Access
In the real world, no one can remember his/her password forever. Especially, you don’t use that password every day you will forget it easily. Even for myself there are many times that I have to email the help desk you re-set my computer login password or program password. In this HowTo, the Re-Set password form will be used for Admin to reset a password to “12345” when the users forgot their password. Follow the step below:
1) Creating a Re-Set password form with a record source data from a tblUser table. If you need help with creating a form then follow my How to Create Form for beginner.
2) Input a Combo box on the Form Header section and select “Find a record on my form based on the value I selected in my combo box.” From the Combo Box Wizard the click Next>>
3) Select UserID, UserName and LoginID fields on the wizard then click Next>>
4) Hide key column on the wizard then click Finish. We want to show only the User name and Login ID fields on the combo box drop-down list.
5) Change the property value of combo box as you want. In this HowTo, I have changed the following formats:
Column Widths = 0;1.5;1
List Rows = 25
List Width = 2.5 (0+1.5+1 = 2.5 from Column Widths)
6) Insert a button at the bottom of form and name it “Reset” for caption. Under the On Click Event Procedure, enter the code below. After the user name is selected on the combo drop-down box, click a Reset button. The password will change to “12345” as shown in the code assigned below:
‘Reset button
Private Sub cmdReSet_Click() Me.Password.Value = "12345" MsgBox "Password reset successfully.", , "Password Reset" End Sub
7) Insert another button and name it as “Close” for caption. Under the On Click Event Procedure, enter the code below. This button will close the form if clicked. The completed Re-set form is shown in the picture below.
' Close button
Private Sub Command39_Click()
DoCmd.Close
End Sub
Related Video:
