Creating Excel Userform with multiple Users

I am trying to create a userform with list of users who can select there name and enter the password and log into the file. Also I want to add Change password button to the form and also all the changed and the current username and password should be stored in Access DB.
Bhushan PatilWork Analysis EngineerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John TsioumprisSoftware & Systems EngineerCommented:
Better to move entirely application to Access...
0
Bhushan PatilWork Analysis EngineerAuthor Commented:
I want to create a userform using excel that's the requirement actually
0
John TsioumprisSoftware & Systems EngineerCommented:
Then just google "tutorial create userform excel" and you will get a ton of info on it.
Since you have Access database in use and probably you use it to feed Excel i reckon is the right point to jump to Access...
0
Neil FlemingConsultant and developerCommented:
Bhushan: try the attached two files.

The Excel workbook implements Microsoft ActiveX dataobjects in tools/references.

The userform fires on workbook open and attempts to connect to the access database attached. It assumes you are using Access 2007-13 in the routine "ConnectDB" (uses a connection string for OLEDB 12).

The connection won't work on your first attempt as the database location is set to my own c: drive in module mTools at:

Public Const DBfolder = "c:\neil work\software\excel\expertsexchangequestions\access\"

Open in new window


So you will get an error popup until you change this location.

Thereafter the login form should populate usernames from the Access table tUsers, and I built some simple tools to check the entered password against the password stored in the database, and to change it. See code in the userform, and in the mTools module.

Right now, all the passwords are the same as the user names.

To test the form, the easiest thing is to type "ulogin.show" in the Immediate window of the VBA code window, rather than re-opening the file.

Hope this sets you on the right path.
PW.accdb
PassWordLogin.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bhushan PatilWork Analysis EngineerAuthor Commented:
Thank you so much Neil Fleming it works.
1
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.