how to disable function keys in access 2010

[rahul2310]

I want to disable function keys in access 2010,for that i am using code on forms on key down event.
Code is

'The forms Key Preview property must be set to Yes
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
 
    Select Case KeyCode
        Case vbKeyDelete
            MsgBox "The Delete key was Pressed"
            KeyCode = 0
        Case vbKeyF1
            MsgBox "The F1 key was Pressed"
            KeyCode = 0
        Case vbKeyF2
            MsgBox "The F2 key was Pressed"
            KeyCode = 0
        Case Else
            'MsgBox "No match!" 'testing
    End Select
 
End Sub
 

This works well but i want to create module and that module will be called in startup form and it will be applicable to call forms and reports.
Is it possible
Thank you in advance

[zmbd]

Create the procedure in a standard code module using parameter, for example

sub trapfunction(byval keydown as Integer)
'remaining code omitted (^_^)

Then for each form where you want to trap the function keys in the Keydown event, call the procedure

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) 
Call trapfunction(KeyCOde)
End Sub 

There is also the AutoKeys macro... it is one of the only special case macros I use as I trap the [F1] and [F11] keys using this macro, even if the bypass key is used, the AutoKeys macro usually works.... be very careful using this macro as you can lock yourself out of things you need.

[NeoPa]

I would suggest a slight modification.

TrapFunction() should, indeed, be a function procedure, rather than a subroutine procedure as shown.

The call to it should assign KeyCode to the result.

Public Function TrapFunction(KeyCode As Integer) As Integer
    'blah di blah
    TrapFunction = {whatever}
End Function

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) 
    KeyCode = TrapFunction(KeyCOde)
End Sub

The rest of the post (#2) is well worth checking out too, as it deals with a very powerful technique to help secure your databases.

[zmbd]

after reading Neopa's suggestion, the function certainly makes more sense. I was only thinking about trapping the key, and not what to do withit afterwards.