Run Access Macro By Using Keyboard

Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.

Run Access Macro By Using Keyboard. You can use the RunMacro method to run a macro. You can also open Microsoft Access from a command line and specify a macro name after the x switch to run it when it opens.

Access Vba Event Handling Tutorial Part 1 First Steps For Beginners Codekabinett
Access Vba Event Handling Tutorial Part 1 First Steps For Beginners Codekabinett from codekabinett.com

If you assign this keyboard shortcut to a macro Access will run the macro instead of the Copy command. Of course you could set the VBA option Break on all errors but that is not desirable in all cases. In the dialog box that shows up select the macro of interest and then click Run.

Start by going to the Developer tab and clicking on the Macros button.

If you dont see the Developer tab on your ribbon you can add it using these instructions Alternatively you can use the keyboard shortcut Alt F8. Create the AutoKeys macro On the Create tab in the Other group click Macro. Enter the key you want to use for the shortcut. From the Categories column choose Macros.