[AccessD] autokeys macros

Jim Dettman jimdettman at verizon.net
Thu May 13 13:28:55 CDT 2021


 That's because they switched from Access Basic to VBA, starting with A95.

Jim.

-----Original Message-----
From: AccessD On Behalf Of John Colby
Sent: Thursday, May 13, 2021 1:23 PM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] autokeys macros

yes but you are doing that from a button.  I am trying to trigger the macro
when a vb editor module is open and you are looking at it.

It appears that this hasn't functioned at any point after Access 97.  It
seems they carved the editor out of access and made it standalone and thus
broke this functionality.
IOW the autokeys macro is in the database now, not visible in the editor.

Sigh.

On Wed, May 12, 2021 at 5:12 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> You mean DOCMD.RUNMACRO Auttokeys? Seems a bit pointless!
>
> But anyway - Office 2010:
>
> Autokeys macro:
> SubMacro ^Q - Action Messagebox "Q"
> SUbMacro ^W Action Messagebox "W"
>
> Button on a form.
> btn-_On Click
>     DocmdRunMacro.Autokeys
>
> Displays messagebox "Q" i.e. the first autokey.
>
>
>
> On 12 May 2021 at 13:44, John Colby wrote:
>
> > Can someone test running an autokeys macro in 2010 or later from
> > inside of a module?
> >
> > It worked back in the day.  I am not getting it to work now.
> >
> > I am running 2010.  I can get the macro to work when not in a module.
> > -- John W. Colby Colby Consulting -- AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd Website:
> > http://www.databaseadvisors.com
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


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



More information about the AccessD mailing list