Adding a Quick Key to a Macro (Access 2000)

Topic

New Reply

I have a macro I am quite happy with, but I failed to add a shortcut key when I wrote it. Is there a way to add a Quick Key after you have completed the macro?

Reply | Quote

Replies

Access is different in this respect than Word and Excel, you can’t assign a shortcut key to a macro the way you can there, through the Customize… dialog. But there are several alternatives:

If you want to assign a shortcut key to execute a macro throughout the database, create a dedicated macro named AutoKeys. Make sure you view Macro Names when editing this macro. Macro names in the AutoKeys macro are keystrokes designated as in the VBA instruction SendKeys, for example:

Notation	Meaning
{F9}	Function key F9
+{F3}	Shift+F3
%{Enter}	Alt+Enter
^{Tab}	Ctrl+Tab

If you want to assign a shortcut to a macro for just one form, handle it in the KeyDown or KeyStroke event of that form, and set the Key Preview property of the form to Yes.

Reply | Quote

Hmm — . I have to confess I’m not sure I understand this. You write a Macro called Autokeys that defines a key (combination of keys) that runs the macro you want a short cut for. Is that close to what you said? How would that make things faster? The Macro I want to run more quickly is an Append macro that adds a newly created table to the master table then deletes the appended table.

Reply | Quote

The AutoKeys macro is opened automatically when you open the database; all shortcut key assignments stored in AutoKeys will be available as long as the database is open. You don’t have to run AutoKeys. So if you wish to assign a shortcut key to your Append macro, set the Macro Name column in AutoKeys to the code for the shortcut key, set the Action to RunMacro, and select the name of your append macro in the lower part of the macro window. When you save the macro as AutoKeys, the shortcut key will be available.

Reply | Quote