Autokey Issues - Access 2000

[Samdaye]

I am trying to find a way to disable my autokeys when I am in my login form. My problem is that when I open my login form, my users can still get out of it by pressing the autokeys. Is there a way that I can disable them in that form only?

Any help would be greatly appreciated.

Thanks.

[MMcCarthy]

I am trying to find a way to disable my autokeys when I am in my login form. My problem is that when I open my login form, my users can still get out of it by pressing the autokeys. Is there a way that I can disable them in that form only?

Any help would be greatly appreciated.

Thanks.

What keys are you referring to exactly?

[Mackabee]

I'm looking to do the same thing. I've set up a login screen but users can get around it to the functions by hitting F1, F2, F3, etc. I need to disable the F keys as soon as Access starts. Anyway to do it?

Sorry. To clarify, I'm running Access 2000.

What keys are you referring to exactly?

[missinglinq]

Goto Properties - Events for your form and set Key Preview to Yes, the in the code module behind your login form:

Private Sub form_keydown(KeyCode As Integer, Shift As Integer)
Dim NewRecHit As Long
 
    Select Case KeyCode
 
        Case vbKeyF2
         KeyCode = 0
 
        Case vbKeyF3
         KeyCode = 0
 
        Case vbKeyF4
         KeyCode = 0        
 
Case Else
 
End Select

You can add as many more FKeys as you like in this manner. It's generally considered bad form to spike F1 (Help) but you can if you like. When moving to another form everything will be restored.

You can use this same technique to cancel the function of most keys as well as to change the function of keys, but always keep in mind the native purpose of the keys! Even if you don't use the normal functions of the keys, your users might!

Welcome to TheScripts!

Linq ;0)>

[Mackabee]

Wicked! That's perfect. I discovered an autokeys macro that activates all the F keys for use in the rest of the database... but I was requested to add a login form and users could skip around it, so I wanted to make sure that they actually legitimately logged in before they could use the special functions.

Thank you so much for the help and the welcome! :-)

Goto Properties - Events for your form and set Key Preview to Yes, the in the code module behind your login form:

Private Sub form_keydown(KeyCode As Integer, Shift As Integer)
Dim NewRecHit As Long
 
    Select Case KeyCode
 
        Case vbKeyF2
         KeyCode = 0
 
        Case vbKeyF3
         KeyCode = 0
 
        Case vbKeyF4
         KeyCode = 0        
 
Case Else
 
End Select

You can add as many more FKeys as you like in this manner. It's generally considered bad form to spike F1 (Help) but you can if you like. When moving to another form everything will be restored.

You can use this same technique to cancel the function of most keys as well as to change the function of keys, but always keep in mind the native purpose of the keys! Even if you don't use the normal functions of the keys, your users might!

Welcome to TheScripts!

Linq ;0)>

[missinglinq]

Glad we could help, Mackabee!

Linq ;0)>