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?
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Adding a Quick Key to a Macro (Access 2000)
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Adding a Quick Key to a Macro (Access 2000)
- This topic has 3 replies, 2 voices, and was last updated 21 years, 10 months ago.
AuthorTopicWSladygnome
AskWoody LoungerJuly 15, 2003 at 7:12 pm #390497Viewing 0 reply threadsAuthorReplies-
WSHansV
AskWoody LoungerJuly 15, 2003 at 7:27 pm #693788Access 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.
-
WSladygnome
AskWoody LoungerJuly 15, 2003 at 8:59 pm #693817Hmm — . 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.
-
WSHansV
AskWoody LoungerJuly 15, 2003 at 9:11 pm #693822The 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.
-
-
Viewing 0 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
A CVE-MITRE-CISA-CNA Extravaganza
by
Nibbled To Death By Ducks
4 hours, 39 minutes ago -
Sometimes I wonder about these bots
by
Susan Bradley
56 minutes ago -
Does windows update component store “self heal”?
by
Mike Cross
17 hours, 36 minutes ago -
Windows 11 Insider Preview build 27858 released to Canary
by
joep517
18 hours, 36 minutes ago -
Pwn2Own Berlin 2025: Day One Results
by
Alex5723
18 hours, 1 minute ago -
Windows 10 might repeatedly display the BitLocker recovery screen at startup
by
Susan Bradley
14 hours, 31 minutes ago -
Windows 11 Insider Preview Build 22631.5409 (23H2) released to Release Preview
by
joep517
21 hours, 18 minutes ago -
Windows 10 Build 19045.5912 (22H2) to Release Preview Channel
by
joep517
21 hours, 19 minutes ago -
Kevin Beaumont on Microsoft Recall
by
Susan Bradley
9 hours, 53 minutes ago -
The Surface Laptop Studio 2 is no longer being manufactured
by
Alex5723
1 day, 5 hours ago -
0Patch, where to begin
by
cassel23
23 hours, 29 minutes ago -
CFPB Quietly Kills Rule to Shield Americans From Data Brokers
by
Alex5723
1 day, 19 hours ago -
89 million Steam account details just got leaked,
by
Alex5723
1 day, 6 hours ago -
KB5058405: Linux – Windows dual boot SBAT bug, resolved with May 2025 update
by
Alex5723
2 days, 3 hours ago -
A Validation (were one needed) of Prudent Patching
by
Nibbled To Death By Ducks
1 day, 18 hours ago -
Master Patch Listing for May 13, 2025
by
Susan Bradley
1 day, 5 hours ago -
Installer program can’t read my registry
by
Peobody
2 hours, 41 minutes ago -
How to keep Outlook (new) in off position for Windows 11
by
EspressoWillie
1 day, 16 hours ago -
Intel : CVE-2024-45332, CVE-2024-43420, CVE-2025-20623
by
Alex5723
1 day, 23 hours ago -
False error message from eMClient
by
WSSebastian42
2 days, 14 hours ago -
Awoke to a rebooted Mac (crashed?)
by
rebop2020
2 days, 23 hours ago -
Office 2021 Perpetual for Mac
by
rebop2020
3 days, 1 hour ago -
AutoSave is for Microsoft, not for you
by
Will Fastie
3 hours, 37 minutes ago -
Difface : Reconstruction of 3D Human Facial Images from DNA Sequence
by
Alex5723
3 days, 4 hours ago -
Seven things we learned from WhatsApp vs. NSO Group spyware lawsuit
by
Alex5723
11 hours, 59 minutes ago -
Outdated Laptop
by
jdamkeene
3 days, 10 hours ago -
Updating Keepass2Android
by
CBFPD-Chief115
3 days, 15 hours ago -
Another big Microsoft layoff
by
Charlie
3 days, 15 hours ago -
PowerShell to detect NPU – Testers Needed
by
RetiredGeek
17 hours, 13 minutes ago -
May 2025 updates are out
by
Susan Bradley
27 minutes ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.