So to help me with not having to do so many admin actions in my database I have created a new user registration form so new people can sign up and start working on their roles in the database.
On my frm_loginform, aside from the username, password, OK button, and Cancel button there are 2 hyperlinks. One is to the frm_registrationform the other is to frm_passchange
I also created a user panel form where users can change their passwords and security questions and answers themselves.
Now I am trying to make the form (frm_passchange) for those who forget their passwords (it happens too often).
tbl_users has:
ID (autonumber)
UserName (short text)
Password (short text)
AccessLvl (number)(values are determined from tbl_accesslevel)
FacilityNumber (short text)(values are determined from tbl_facilities)
EmailAddress (short text)
MachineID (number)
FullName (short text)
Question1 (short text)
Answer1 (short text)
Question2 (short text)
Answer2 (short text)
Question3 (short text)
Answer3 (short text)
I made a new table called tbl_securityquestions with the questions to choose from.
I made a form named frm_passchange with:
*An unbound combobox for them to choose their username from the dropdown with a query (qry_inputusername) as the row source.
*An unbound combobox with a query (qry_securityquestions) for security question 1
*An unbound testbox for the answer to security question 1
*An unbound combobox with a query (qry_securityquestions) for security question 2
*An unbound testbox for the answer to security question 2
*An unbound combobox with a query (qry_securityquestions) for security question 3
*An unbound testbox for the answer to security question 3
So here is the question and plea for help.
I need the code behind this form to make everything happen.
First thing first... once the username is chosen and they choose their saved questions and answers from when they registered... the code needs to verify the username, questions and answers match the values in the fields in the tbl_users.
Then a command button to submit the request and change their password to "password" and redirect them back to the frm_loginform where they can then login with their username and password as their password.
Then the code to look for users with their password as "password" and direct them to their user panel for them to change the temporary password to a different one.
I hope all that made sense.
Is there anyone willing to write some code to help me with this?
I have been searching and reading online for days and nothing really touches on this I can find.
On my frm_loginform, aside from the username, password, OK button, and Cancel button there are 2 hyperlinks. One is to the frm_registrationform the other is to frm_passchange
I also created a user panel form where users can change their passwords and security questions and answers themselves.
Now I am trying to make the form (frm_passchange) for those who forget their passwords (it happens too often).
tbl_users has:
ID (autonumber)
UserName (short text)
Password (short text)
AccessLvl (number)(values are determined from tbl_accesslevel)
FacilityNumber (short text)(values are determined from tbl_facilities)
EmailAddress (short text)
MachineID (number)
FullName (short text)
Question1 (short text)
Answer1 (short text)
Question2 (short text)
Answer2 (short text)
Question3 (short text)
Answer3 (short text)
I made a new table called tbl_securityquestions with the questions to choose from.
I made a form named frm_passchange with:
*An unbound combobox for them to choose their username from the dropdown with a query (qry_inputusername) as the row source.
Code:
SELECT [tbl_users].[UserName]
FROM tbl_users
ORDER BY [UserName];
Code:
SELECT tbl_securityquestions.Questions, tbl_securityquestions.Questions
FROM tbl_securityquestions
ORDER BY tbl_securityquestions.Questions;
*An unbound combobox with a query (qry_securityquestions) for security question 2
Code:
SELECT tbl_securityquestions.Questions, tbl_securityquestions.Questions
FROM tbl_securityquestions
ORDER BY tbl_securityquestions.Questions;
*An unbound combobox with a query (qry_securityquestions) for security question 3
Code:
SELECT tbl_securityquestions.Questions, tbl_securityquestions.Questions
FROM tbl_securityquestions
ORDER BY tbl_securityquestions.Questions;
So here is the question and plea for help.
I need the code behind this form to make everything happen.
First thing first... once the username is chosen and they choose their saved questions and answers from when they registered... the code needs to verify the username, questions and answers match the values in the fields in the tbl_users.
Then a command button to submit the request and change their password to "password" and redirect them back to the frm_loginform where they can then login with their username and password as their password.
Then the code to look for users with their password as "password" and direct them to their user panel for them to change the temporary password to a different one.
I hope all that made sense.
Is there anyone willing to write some code to help me with this?
I have been searching and reading online for days and nothing really touches on this I can find.