sendkeys.

[buggy2]

I have designed a login form which runs from an autoexec macro for a database. The functionality is fine except that i need to check the password when the user hits the return key. I presume you can use 'sendkeys "{RETURN}" ' in access, but i am not a fan of it at all.

So the problem is: user hits 'enter' instead of clicking ok and the password is correct, then access should be allowed. I sense this will be standard.

 

[DRB]

Just signed up for Excel, but thought I'd check out Access board.

Your problem was one I had to work at for awhile, the answer is so simple you are going to hate it.

All you have to do is set the OK button on your form as the Default. Once you do this it has keyboard focus even though your cursor is placed in your password text box.

I usually will have the focus return to the password text box after someone has entered a wrong password or entered null. Of course the null has to be handled as an error routine.

Here's some code:

Sub CheckPassword()
On Error GoTo err
Dim LookupPassword As String

EnteredPassword = Me.txtPassword

LookupPassword = DLookup("Text", "Entities", "Identity = 'MyPassword'")

If EnteredPassword = LookupPassword Then
MsgBox "Congratulations!"
DoCmd.Close
Else
MsgBox "The password you have entered is incorrect."
Me.txtPassword.SetFocus
End If

Exit Sub

err:
If err = 94 Then
MsgBox "Please enter a password"
Me.txtPassword.SetFocus
Else
MsgBox err & ": " & err.Description
End If

 

[buggy2]

sendkeys

works perfect many thanks, you were right it was a simple solution.