MsgBox 'Password reset successfully.',, 'Password Reset'ħ) Insert another button and name it as “Close” for caption. ‘Reset button Private Sub cmdReSet_Click()

The password will change to “12345” as shown in the code assigned below: After the user name is selected on the combo drop-down box, click a Reset button. Under the On Click Event Procedure, enter the code below. List Width = 2.5 (0+1.5+1 = 2.5 from Column Widths)Ħ) Insert a button at the bottom of form and name it “Reset” for caption. In this HowTo, I have changed the following formats:

We want to show only the User name and Login ID fields on the combo box drop-down list.ĥ) Change the property value of combo box as you want. If you need help with creating a form then follow my How to Create Form for beginner.Ģ) 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>ģ) Select UserID, UserName and LoginID fields on the wizard then click Next>Ĥ) Hide key column on the wizard then click Finish. Follow the step below:ġ) Creating a Re-Set password form with a record source data from a tblUser table. 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. 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. Especially, you don’t use that password every day you will forget it easily. In the real world, no one can remember his/her password forever. How to Create Re-Set password for Admin: MS Access

Reset ms access password