Hi
Is there a way, where I can give a option in login form for users to set or change their password for db?
Hi
Is there a way, where I can give a option in login form for users to set or change their password for db?
any suggestions on this one?
I assume that you currently have a combo box or text box for the user name and a text box for their current password. My suggestion would be to add two hidden text boxes on the login form. One for the new password and another for it's confirmation. Once the current password has been confirmed, the two new text boxes can be shown.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Hi
Thanks for the reply, to be honest I am a beginnner so I dont have much idea. I have something like this which I have seen on you tube and put it in my application:
and when user enter a predefined username and password and click enter this code runs
Private Sub Command5_Click()
Username.SetFocus
If Username = "user1" And Password = "user1" Then
DoCmd.Close
DoCmd.OpenForm "F_switchboard"
Else
MsgBox "Username and/or Password are incorrect."
End If
End Sub
Since I want to distribute my application to different users, I want to add the feature for users to create their own UN and PW, because if I use the above mentioned system I will have to create UN and PW for each user and they will have to remember it always. And this application is an offline application.
Why not distribute the app with one user and password already entered. Perhaps something like user name "Admin", password "LetMeIn".
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
But then what is the use of username and password when everyone has the same?
Well to get them into the app to start with, so that they can change them to their own choice.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick