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,


Hailey
www.msaccessrepair.com - Access Recovery

You can make buttons to run your macros, and then Hot Keys for those buttons. But you would have to have a form open for this to work.

If you create a form with all the buttons to run your macros, then create Hot Keys for the buttons, then open the for acHidden when the database opens, this will give you the functionality you want. There may be a more elegant way, though, like custom menus with Hot Keys for the menu buttons.

Did any of that help?


mmcdonal

Hi Hailey,
What are you tryring to achieve. Where are you using the Hot keys? - In a form, in code? You can use the sendkeys in both macros and vba by writing the combination of the keys you want pressed.