[AccessD] GGCCErrorHandler

[John Colby]

Look what I found!

Automating the VB Editor itself. <http://www.cpearson.com/excel/vbe.aspx>

Of course the examples are for Excel but I think I can use it in Access as
well!

We shall see.

On Mon, May 10, 2021 at 8:02 PM John Colby <jwcolby at gmail.com> wrote:

> BTW the actual insertion code works a treat.  If I swite the name of the
> function or sub and then call the function that does it all, the error
> handler is inserted just fine.
>
> The macro is supposed to use sendkeys to highlight the line the cursor is
> in, then copy it to the paset buffer, then call that function.
>
> I am strongly suspecting that Access has disabled the SendKeys
> functionality or something.  I am not getting that (sendkeys) to work in a
> plain old function for testing.  Plus it puts up a yellow ! in the macro.
>
> On Mon, May 10, 2021 at 7:58 PM John Colby <jwcolby at gmail.com> wrote:
>
>> Autoexec does work, it opens the only form to display a simple help.
>>
>> On Mon, May 10, 2021 at 7:36 PM Stuart McLachlan <stuart at lexacorp.com.pg>
>> wrote:
>>
>>> Do any other macros work?
>>>
>>> How about trying a simple MsgBox in AutoExec to test?
>>>
>>>
>>> On 10 May 2021 at 19:19, John Colby wrote:
>>>
>>> > Long ago in a universe I co-wrote an error handler insertion wizard
>>> > with Glen Grub.  I am trying to get it running again because I want
>>> > error handlers.
>>> >
>>> > I cannot for the life of me get an autokey macro to trigger.  The
>>> > macro is supposed to do a sendkey to copy a section of code to the
>>> > windows paste buffer and then call a function to process that stuff.
>>> >
>>> > One would think if nothing else, if the macro triggered then the
>>> > selected code would be in the paste buffer.  No Joy.  Furthermore an
>>> > initial beep doesn't.
>>> >
>>> > All of which tells me that it isn't triggering.
>>> >
>>> > I have set the trust center and enabled macros in there.  What else am
>>> > I missing?
>>> >
>>> > --
>>> > 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
>>
>
>
> --
> John W. Colby
> Colby Consulting
>


-- 
John W. Colby
Colby Consulting