Code to change user login password?
In Suppose I have enter username , password in login page and when I click on change password button the new screen will be open which contain User name,old password,new password and confirm password.
I user name textbox login user name should be display in a readable mode .so,user can only enter old,and new password and click update.that new password will update in a database.I havesome code but its not functioning properly.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I don't use a default password because every newly created user has different auto generated password.
I have a form and a table login(user, password, role)where user can login with username and password by referring to Login table.
How can I view the role in MsgBox according to username and password in table login? I'm having trouble in here (Underline words). The Logic is if username and password has been filled and then search in table. If Its TRUE then it will show MsgBox with the role user in table Login.
Or do you have any better codes for this?
What Happen? - I created a login form, where a user enters the login details. It was working fine and I loaded the login form as the form to open when access starts. Each time I open the DB I can see access 2007 popping up before the login form shows, also the background appears.
I was trying to get rid of the background and the access 2007 start screen. I just wanted the login form to show. I then changed the following controls:
Allow Add. = No
Allow Del. = No
Allow Edits = No
Allow Filters = No
Data Entry = No
I saved the form and THEN.
When I started the DB, it do not do the required results and it would not allow me to enter the user details to login. all this said, I cannot access the db to change.
SOmetime back I result some DAO process where you can access another database and not the current one. I would like to do similar code to reset the password on the useraccess table so whenI start my data base it will access a blank password.
It works fine for the first user record in the table but for subsequent users I receive the error message even though the Employee Name and Password combination is correct.
I am hung up on how to get the login information to transfer over to the form. Here is the code that controls the login process;
All I need is the username. And then I need it to autopopulate a field in a form.
Environ("UserName") for the username.
Also I would like to add. I have a table that has of the users in it along with their NTID (Username). What kind of code can I write that checks to see if their current username = the tbl username?
What I have now looks like this:
I don't want the user to have to select their name on every entry but just log in once when opening the program and then have that name saved. Howcan I do this? If I keep the login form open then I believe I can figure it out, but I would really like the login form to disappear after selecting a user.
Here's what I'd LIKE to have happen: when the user opens the application (Access2k), a dialog box appears with the windows login name of the currently-logged in user (I can do this part), and they have to enter their WINDOWS password, which some windows api verifies for me so I can allow or not allow them in.
Is there a way for windows to verify the password for me? I can't seem to find anything on this; all I get are directions to fOsusername, which is only the first half of my battle.