TheSafetyGuy86
Registered User.
- Local time
- , 20:18
- Joined
- Jun 18, 2013
- Messages
- 31
Password Help
Good day,
I have a table that contains user names and passwords (yes, I know that I should hash them, but that kind of code and it's processes are beyond my current understanding) and I have a form that allows the users to select their username and then enter their password. When they click a button, it compares the password stored in the table to the password entered and then opens the main form. The problem I have is that the code doesn't recognize capital letters. I can simply place the password in there with any form of lettering and it will read. I want it to read the password exactly as it is placed on their initial setup.
If EPassword = SPassword Then
DoCmd.OpenForm "Selector", acNormal, "", "", acFormAdd, acWindowNormal, ""
Else
MsgBox "The password entered is incorrect. Try Again.", vbExclamation, "Wrong Password!"
Me.EPassword = ""
:banghead:
of all things, this is probably one of the simplest things to do, but I have to admit that I don't understand completely the VBA codes enough to complete this on my own. Does anyone know what I need to do to fix this and would you please give me the run down. On the same note, if anyone knows the process for using a one way hash and can explain it by steps, that would be awesome too. Trust me, I am a very fast learner and can work things out on my own, but it has been complicated to learn everything involved so far. Thank you and have a good day.
Lee
Good day,
I have a table that contains user names and passwords (yes, I know that I should hash them, but that kind of code and it's processes are beyond my current understanding) and I have a form that allows the users to select their username and then enter their password. When they click a button, it compares the password stored in the table to the password entered and then opens the main form. The problem I have is that the code doesn't recognize capital letters. I can simply place the password in there with any form of lettering and it will read. I want it to read the password exactly as it is placed on their initial setup.
If EPassword = SPassword Then
DoCmd.OpenForm "Selector", acNormal, "", "", acFormAdd, acWindowNormal, ""
Else
MsgBox "The password entered is incorrect. Try Again.", vbExclamation, "Wrong Password!"
Me.EPassword = ""
:banghead:
of all things, this is probably one of the simplest things to do, but I have to admit that I don't understand completely the VBA codes enough to complete this on my own. Does anyone know what I need to do to fix this and would you please give me the run down. On the same note, if anyone knows the process for using a one way hash and can explain it by steps, that would be awesome too. Trust me, I am a very fast learner and can work things out on my own, but it has been complicated to learn everything involved so far. Thank you and have a good day.
Lee
Last edited:
.
