Compare two passwords

[AmanKaur123]

Hi All



I am building a form to generate unique passkey for each user. So there are 2 textboxes named
1. Create a Password
2. Confirm your Password

Now I want to check if both the passwords are same. If I write the following code, It always shows "Doesn't match"

Dim rs As Recordset
Set rs = CurrentDb.OpenRecordset("tbl_RMS_PassKey")
If StrComp(txtPass, txtConfirmPass, vbBinaryCompare) = 0 Then
MsgBox "Match occurred"
else
msgbox "Match doesn't occur"
end if

If I change the above line code with the following then it still shows "doesn't match"

if txtpass=txtConfirmpass then

ANy help will be much appreciated.

Thanks

[ranman256]

your code ,StrComp(txtPass, txtConfirmPass, vbBinaryCompare) = zero, means false.
if false then
match
else
match doesnt occur
endif

since it IS true, then 'match doesnt occur'.
make it
IF StrComp(txtPass, txtConfirmPass, vbBinaryCompare) THEN

[AmanKaur123]

sorry it worked fine. I didn't make any change but it worked. I had to transfer the setfocus to a different control.

[AmanKaur123]

Also any idea for the passwords that users can type? Any validations on the passwords? Any suggestions are welcome. Thanks

[kagoodwin13]

Also any idea for the passwords that users can type? Any validations on the passwords? Any suggestions are welcome. Thanks

My suggestion would be to search other people's threads for ideas on how to create good user security within Access. Access does not come pre-built with any security features.

There are some validation rules that would be simple. For example, to validate a password is at least 8 characters, VBA can be used:

If Len(txtPassword) < 8 Then 
Call MsgBox "Your password is not long enough."
Else
Call MsgBox "Password is long enough."
End If

Other validation rules, such as at least one Upper case and one lower case and one number are included, would require more complex VBA. See more here: http://www.excelforum.com/excel-prog...ion-print.html