User Name & Password Log In Issue

[KLahvic]

Okay - I have a 3 2 user forms, plus a calandar pop-up user form. One is a Log In Screen with a user id combo box and a password textbox referenced to ranges in a very-hidden sheet. My second form is a spend tracker with mulitple fileds, text boxes, combo boxes, etc. One of the fields in the spend tracker is user name, what I would like to do is when a user enters their user name and password the entered user name as long as it matches one in the database be populated in the user name field and not allow it to be edited. Is there a way to do this, if so, what is the code and where do I put it.

I will attach my file so you can check it out. Log in: tester
Password: test01

Programmers Access Code is 1234.

[royUK]

You hven't provided a user name or password, cancellin leaves an invisible instance of Excel running. If yo are going to hide the excel application at least make sure that error handling of some sort restores the application!

[royUK]

You need the username declaring as a Global variable, then it can be used in the next userform & the textbox's enabled property can be set to False

[KLahvic]

I did provide a user name and a password. user name: tester password: test01

and I thought I did reenable it by using application.visible: here is the code i used for that, let me know if it is wrong. I put it in thisworkbook:

Please Login or Register  to view this content.

If this is wrong, please let me know how to fix it.

[royUK]

Add a module to the project and type in it

Please Login or Register  to view this content.

Amend he login code to

Please Login or Register  to view this content.

[KLahvic]

Royuk -

I think we are getting somewhere, however, when I run the program and log in the word user name is what is populated in the user name field. Is there something that I am missing? I was hoping to have the actual user name populated. I'm sure it is a simple fix, but I am clueless.

Thank you for your patience and help with this matter.

[royUK]

I though you wanted the user name that is entered into the login box. That's what should happen if he login is sccessful the next form will have that name pre-entered.

[KLahvic]

Roy

You are correct, that is exactly what I want to have happen. However, when I log in with my user name and password the word "User name" shows up, not actual name typed in the user name field of the login box.

[royUK]

Change this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[KLahvic]

Thank you very much, this works exactly the way I wanted it to work.

SOLVED!

Ken