Solved

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

Posted on 2014-12-23
3
111 Views
Last Modified: 2014-12-23
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
Comment
Question by:wlwebb
  • 2
3 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40514821
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
 

Author Comment

by:wlwebb
ID: 40514987
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
 

Author Closing Comment

by:wlwebb
ID: 40515091
Got it............

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

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question