[AccessD] Detached event procedures

Stuart McLachlan stuart at lexacorp.com.pg
Thu Mar 12 02:18:34 CDT 2015


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





More information about the AccessD mailing list