[AccessD] GGCCErrorHandler

[John Colby]

LOL yea.  I own 6.0 though the license is long lost.

However there is a certain satisfaction in knowing how stuff works.

On Mon, May 10, 2021 at 8:27 PM Jim Dettman via AccessD <
accessd at databaseadvisors.com> wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
John W. Colby
Colby Consulting