[AccessD] Detached event procedures

[Bill Benson]

Me too. In fact really I said it because Hee'sssss Baaaaack!
On Mar 12, 2015 3:20 AM, "Stuart McLachlan" <stuart at lexacorp.com.pg> wrote:

> I knew you would :)
>
> --
> Stuart
>
> On 11 Mar 2015 at 15:56, John W. Colby wrote:
>
> > ROTFL.  I second that!
> >
> > John W. Colby
> >
> > On 3/11/2015 3:21 PM, Bill Benson wrote:
> > > 50 + events? Class modules anyone?!
> > >
> > > On Sat, Mar 7, 2015 at 11:08 AM, Gustav Brock <gustav at cactus.dk>
> > > wrote:
> > >
> > >> Hi Dan
> > >>
> > >> Yes, that works but - facing 50+ events - I looked for a less
> > >> tedious procedure.
> > >>
> > >> /gustav
> > >>
> > >> ________________________________________
> > >> Fra: accessd-bounces at databaseadvisors.com <
> > >> accessd-bounces at databaseadvisors.com> på vegne af Dan Waters <
> > >> df.waters at outlook.com> Sendt: 7. marts 2015 17:02 Til: 'Access
> > >> Developers discussion and problem solving' Emne: Re: [AccessD]
> > >> Detached event procedures
> > >>
> > >> Hi Gustav,
> > >>
> > >> After you paste the control onto the tab form, you can open the
> > >> property sheet for the control, select the Event tab, and then
> > >> select Event Procedure for the event in question.  If the procedure
> > >> has its default name, then they should be hooked up.
> > >>
> > >> Sometimes my controls get 'unhooked' and that works for me.
> > >>
> > >> HTH!
> > >> Dan
> > >>
> > >> -----Original Message-----
> > >> From: accessd-bounces at databaseadvisors.com
> > >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav
> > >> Brock Sent: Saturday, March 07, 2015 8:39 AM To: Access Developers
> > >> discussion and problem solving Subject: [AccessD] Detached event
> > >> procedures
> > >>
> > >> ?Hi all
> > >>
> > >>
> > >> If you on a form decide to move some controls into a tab control,
> > >> you normally do a cut and paste of these controls - from the form
> > >> into a page of the tab control.
> > >>
> > >> Then all the events of the controls get cleared; the [Event
> > >> Procedure] markings are gone and the code behind is detached though
> > >> still present.
> > >>
> > >>
> > >> To restore these settings, open the code module of the form:
> > >>
> > >>
> > >> 1. Mark all code with Ctrl+A
> > >>
> > >> 2. Cut it away with Ctrl-X
> > >>
> > >> 3. Select menu Debug, Compile
> > >>
> > >> 4. Paste all the code back into the empty module with Ctrl-V
> > >>
> > >> 5. Select Debug, Compile
> > >>
> > >>
> > >> Now your event procedures are hooked up again.
> > >>
> > >>
> > >> I knew of this little trick but had forgotten the details and found
> > >> it here after much searching:
> > >>
> > >>
> > >> http://bytes.com/topic/access/answers/632851-detached-event-procedu
> > >> res
> > >>
> > >>
> > >> /gustav
> > >> --
> > >> AccessD mailing list
> > >> AccessD at databaseadvisors.com
> > >> http://databaseadvisors.com/mailman/listinfo/accessd
> > >> Website: http://www.databaseadvisors.com
> > >>
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>