By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,145 Members | 1,542 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,145 IT Pros & Developers. It's quick & easy.

Hotkeys in macros

P: 6
Hi, all. I have another question. Can anyone tell me how I can attach a hotkey combination (e.g. CTRL+M) to a macro or a bit of VBA code in order to activate the macro or code in MS Access?

Thanks in advance.

Kind regards,
Sep 6 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 374
You can use the OnKeyPress event handler to find out what key was pressed, but if you're also entrying data on the same screen, that is a great deal of overhead.

Currently that would be the only way that Access supports special control keys and stuff. But it's not an easy thing to work it by any means. I would do it with on_Click events with buttons on a form or pulldown menus.

Hope that helps,

Joe P.
Jan 15 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.