Change a "OnKeyPress" bind for the database to recognize at all times

[kdbailey]

Similar to how Excel uses "Application.OnKey" I would like my F11 key to automatically open up a table. Does access allow for this?

[ItsMe]

perhaps create an Auto Key macro with a submacro of {Fn11}

[kdbailey]

Can you explain this a little further?

[ItsMe]

Create a macro that will open the table or whatever task you want to accomplish. Create another macro and name it AutoKeys. Type the keyboard shortcut that you want to intercept in the macro name collumn. Use the pulldown in the command to select Run Macro. Name your macro that you previously created.

I tried creating an F11 intercept and the system would not let me. Not sure why. I believe it is still possible. Here is an example of intercepting Ctrl+k to display a message box.

.

[kdbailey]

I am a bit confused as to how you have a "Macro Name" field in your macro design.

I only have the Action/Arguments/Comments Fields.

[ItsMe]

When the Macro is open in design view you can select View>Macro Names from the menu bar (top of the screen).