[AccessD] Detached event procedures

[John W. Colby]

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