[AccessD] GGCCErrorHandler

[Jim Dettman]

They do work, and you can reference the modules through the documents collection or through Application.VBE.

  But really, I’d just buy Mz tools rather than re-invent the wheel.

Jim

Sent from my iPhone

> On May 10, 2021, at 8:12 PM, John Colby <jwcolby at gmail.com> wrote:
> 
> 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
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com