Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Solved: Create a "Change Password" form for Login in Access 2007


(!)

krs1716's Avatar
krs1716 krs1716 is offline
Member with 438 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Intermediate
27-Apr-2012, 09:12 AM #1
Solved: Create a "Change Password" form for Login in Access 2007
Hello All! I have created a database that uses a login form that directs people to specific forms based on priviledges. However, I would like to provide a form that allows users to change their passwords (preferably with a confirm password box). Also, I have one user defined as Administrator, with a special form. I would like to create a special form for the Administrator to be able to add/delete/edit users and their security levels.

I found similar threads, but none that answered my specific questions- relative to my current setup.

Thoughts?
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
27-Apr-2012, 11:45 AM #2
Did you use my Login Form?
It would only take a minor modification to create what you need for changing the password.
krs1716's Avatar
krs1716 krs1716 is offline
Member with 438 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Intermediate
27-Apr-2012, 12:25 PM #3
I don't know if I'm using your login form. I found coding and references in multiple places and pieced them together to create a login form that worked for me.

The database I'm referencing is the same one that we've discussed in other threads (i.e. Creating a monthly query/report in Access 2007)
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
27-Apr-2012, 12:51 PM #4
It is not my login form.
Do you want to use a VBA Recordset or SQL to update the tblEmployees table or use that table as the record Source for the Password change form?
krs1716's Avatar
krs1716 krs1716 is offline
Member with 438 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Intermediate
27-Apr-2012, 02:14 PM #5
I don't really know what the benefits/faults are of each method...so it doesn't really matter to me. Do you think that one method is better than the other?
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
28-Apr-2012, 06:00 AM #6
The simplest method is to use the table/query as the Form record source.
krs1716's Avatar
krs1716 krs1716 is offline
Member with 438 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Intermediate
28-Apr-2012, 09:39 AM #7
That works for me. Do I just start by making a form with that as the record source and then add the CBS?
krs1716's Avatar
krs1716 krs1716 is offline
Member with 438 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Intermediate
28-Apr-2012, 09:39 AM #8
Whoops...vba. Autocorrect at work.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
29-Apr-2012, 06:17 AM #9
Yes, that is the way, but you could hide the fields if you want and use unbound fields for the updating on the form and then VBA to update the hidden fields.
krs1716's Avatar
krs1716 krs1716 is offline
Member with 438 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Intermediate
29-Apr-2012, 11:56 AM #10
Well, my original thought was that after employees chose their name, typed in their password, and clicked login, a form or message box (not sure which would be best) would appear asking if they would like to change their password. If they chose "No", they would be directed to the home page. If they chose yes, they would be directed to a form that showed their Name (unchangeable field) and a box where they type in the old password, new password, and confirm new password. VBA would then confirm the old password and check to make sure the new password and confirm new password were the same before changing the password in the table. Not sure how that fits into what you mentioned, but I'm slightly confused about the unbound fields and hidden fields.

Is that too complicated? Is there a better way? Would I be better off changing my login form to your login form and going about this from that perspective?
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
29-Apr-2012, 12:33 PM #11
Your method would work well, can I suggest that you just have a button on the Form for "Change Password" rather than a pop up?
krs1716's Avatar
krs1716 krs1716 is offline
Member with 438 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Intermediate
29-Apr-2012, 12:46 PM #12
A button on the Home page?
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
29-Apr-2012, 01:28 PM #13
Yes or the login form?
krs1716's Avatar
krs1716 krs1716 is offline
Member with 438 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Intermediate
29-Apr-2012, 01:51 PM #14
Okay. I put a button on the Home page, but I don't know how to make the right change password form to open. As of now, it opens a blank version.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
30-Apr-2012, 04:39 AM #15
Have you created the new Password Change form?
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑