[AccessD] [EXTERNAL] Autokeys

[Shane Groff]

Check out: https://support.microsoft.com/en-us/office/run-an-access-macro-by-using-a-keyboard-shortcut-0d267570-d3da-46eb-9bfb-a3c81af676be

-----Original Message-----
From: Shane Groff
Sent: Tuesday, May 2, 2023 2:52 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: RE: [AccessD] [EXTERNAL] Autokeys

You're right, Stuart, I was thinking the tip mentioned the Ctrl+M syntax, but it was just pointing out how to create a menu keyboard shortcut.

I don't know if we have documentation that specifically describes using SubMacros in the Autokeys macro (we probably should).

Shane

-----Original Message-----
From: AccessD <accessd-bounces+shaneg=microsoft.com at databaseadvisors.com> On Behalf Of Stuart McLachlan
Sent: Tuesday, May 2, 2023 2:48 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] [EXTERNAL] Autokeys

That link doesn't really explain Autokeys, it is about popup menus.  It doesn't even mention things like Ctlr+M to invoke an action.

To answer the question:

Create a new Macro.
Select "SubMacro" as the Action - Note that it is near the top of the picklist, not in the alphabetical list of actions.
Enter your Hotkey "^M" in place of "Sub1"
Select your desired action in "Add New Action" and complete any parameters.
Save it as Autokeys.
... Voila.

You can add additional Hotkeys by adding new "SubMacro"s below the "End Submacro"




On 2 May 2023 at 17:04, Shane Groff via AccessD wrote:

> You still create an Autokeys macro, but you need to use submacros
> (https://sup/
> port.microsoft.com%2Fen-us%2Foffice%2Fcreate-custom-menus-and-sh&data=
> 05%7C01%7Cshaneg%40microsoft.com%7Ceb0a60fc8f8a4405a2ea08db4b56df23%7C
> 72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C638186608772612463%7CUnknow
> n%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLC
> JXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=UIidv%2FLlAjYRXs50MYjl5UW9d5I0cm0t9
> l6I7QjE1tg%3D&reserved=0
> ortcut-menus-by-using-macros-5bd538ff-19c4-4dfe-9540-3309aebf8a1a) to
> define the shortcuts.  See the Tip about using a submacro to create a
> shortcut key in Step 1, 2a
>
> Shane
>
> -----Original Message-----
> From: AccessD
> <accessd-bounces+shaneg=microsoft.com at databaseadvisors.com> On Behalf
> Of John Colby Sent: Tuesday, May 2, 2023 9:43 AM To: Access Developers
> discussion and problem solving <accessd at databaseadvisors.com>; John
> Colby <jwcolby at gmail.com> Subject: [EXTERNAL] [AccessD] Autokeys
>
> Trying to make an autokeys macro in A2019.  The Access UI has changed
> since the 2010 article I found.  I want to make a ^M (Ctl M) to open a
> switchboard.  How is this done now?
>
> --
> John W. Colby
> Colby Consulting
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://data/
> baseadvisors.com%2Fmailman%2Flistinfo%2Faccessd&data=05%7C01%7Cshaneg%
> 40microsoft.com%7Ceb0a60fc8f8a4405a2ea08db4b56df23%7C72f988bf86f141af9
> 1ab2d7cd011db47%7C1%7C0%7C638186608772612463%7CUnknown%7CTWFpbGZsb3d8e
> yJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C30
> 00%7C%7C%7C&sdata=c9zM2Njy4SGQ%2BEat4P7ZC5wvZpSK%2BcKW9GacxIj%2F32I%3D
> &reserved=0
> Website:
> http://www.d/
> atabaseadvisors.com%2F&data=05%7C01%7Cshaneg%40microsoft.com%7Ceb0a60f
> c8f8a4405a2ea08db4b56df23%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7
> C638186608772612463%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIj
> oiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=eFeelN8
> %2B%2FqxIhcGYoDO0ThfkCZgIJjhb9%2FY%2BFJaTqI4%3D&reserved=0
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://data/
> baseadvisors.com%2Fmailman%2Flistinfo%2Faccessd&data=05%7C01%7Cshaneg%
> 40microsoft.com%7Ceb0a60fc8f8a4405a2ea08db4b56df23%7C72f988bf86f141af9
> 1ab2d7cd011db47%7C1%7C0%7C638186608772612463%7CUnknown%7CTWFpbGZsb3d8e
> yJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C30
> 00%7C%7C%7C&sdata=c9zM2Njy4SGQ%2BEat4P7ZC5wvZpSK%2BcKW9GacxIj%2F32I%3D
> &reserved=0
> Website:
> http://www.d/
> atabaseadvisors.com%2F&data=05%7C01%7Cshaneg%40microsoft.com%7Ceb0a60f
> c8f8a4405a2ea08db4b56df23%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7
> C638186608772612463%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIj
> oiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=eFeelN8
> %2B%2FqxIhcGYoDO0ThfkCZgIJjhb9%2FY%2BFJaTqI4%3D&reserved=0
>


--
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com/