• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 124
  • Last Modified:

Access07 - Can you create Shortcut or Special Function keys in Acess?

Hello Experts.

I have an unbound keypad form that I want to the user to be able to bring up whenever they are in a numeric input field.  To do that, I envision them hitting the F7 or some other non dedicated by access Function key.  Is there a way to do this?
0
wlwebb
Asked:
wlwebb
  • 2
1 Solution
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Yes, by using an AutoKeys macro. It's based on very old technology, but it still works.

Create - Macro.

Go to Design - Show/Hide - Macro Names.

In the Macro Name column, press F7.

In the Action column, put your action, e.g. RunMacro, and complete the rest of the section.

Save the Macro as AutoKeys.

For more information, see https://support.office.com/en-sg/article/Run-an-Access-macro-by-using-a-keyboard-shortcut-0d267570-d3da-46eb-9bfb-a3c81af676be
0
 
wlwebbAuthor Commented:
Ok... I tried this.....

Created a Macro that I saved as [F7Macro]
in the macro Name field first I tried just hitting the F7 key... it put nothing there so I typed {F7}
Action is RunMacro
Arguments is OpenKeypad,1,1

Created a Macro that I saved as [OpenKeypad]
In that I put
Action OpenForm
Arguments frm_Keypad,Form,,,,Normal

When I hit F7 key nothing happens.... but if I double click on the Navigation bar F7Macro it does open the keypad form.

?????????????????????
0
 
wlwebbAuthor Commented:
Got it............

The step I missed was the Save As.... that you HAVE TO type Autokeys ... it's a hidden option
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now