Can i assign keyboard commands in place of a mouse click?

[wcook101]

I have a button that adds a new customer and it does get tedious reaching for the mouse to simply add a new record when data entry could be faster using something an F10 or whatever. Is there a way to assign a keyboard command in access 2016 to replace the need to click the button?
Thanks

[CJ_London]

include an ampersand before a character in your button caption e.g.


&New

will display

New

and the click event will run if the user hits caps/alt/n (i.e. Alt-N)

or use
&new

displays

new

and the click event will run if the user hits alt/n (i.e. Alt-n)

you can also put the ampersand elsewhere in the caption e.g.

New &Project

if you want to do away with your button, you can assign macros to keys - see this link https://support.office.com/en-gb/article/run-an-access-macro-by-using-a-keyboard-shortcut-0d267570-d3da-46eb-9bfb-a3c81af676be

[Gicu]

See these links:
https://stackoverflow.com/questions/...cess-2007-form
https://www.fmsinc.com/microsoftacce...rtcut_keys.htm
Cheers,

[ssanfu]

Here is a demo of the code I use.
Pressing the F11 key opens a different form, hiding the main form. Closing the form and the main form appears again.
Click in a row for Field3 and pressing F12 will open a different form.

IMPORTANT!!
In any form that you want to assign a key combo, open the properties dialog, click on the EVENTS tab. At the bottom, set the Key Preview property to TRUE.


Don't remember where I found the code......


EDIT - missed a line (while copy & paste) - fixed now.....

[wcook101]

I had tried that before this but could not find the "Key Preview" Property. I didnt realize at the time it was a form property. Thanks

[Missinglinq]

How about simply pressing the <Enter> key?

In Design View...with the Command Button selected...go to Properties - Other and set the Default Property to Yes. Pressing <Enter> is now the same as clicking on the button.

This can only be done for one Command Button per Form.

Linq ;0)>