From: Larry R Harrison Jr [larrytucaz@mindspring.com]
Sent: Thursday, February 08, 2001 7:44 AM
To: Larry Harrison
Subject: converting macros to modules, then refering them
Subject: Re: converting macros to modules, then refering them
Date: 02/08/2001
Author: Michel Walsh <Vanderghast@msn.com>

post reply << previous in thread  ·  next >>

Hi,
 
 
Inside the onEvent procedure, type the name of the subroutine:
 
Private Sub Command1_Click()
    YourSubroutineNameHere( WithArgumentsIfAny )    ' <<<add this line End Sub
 
 
 
If the code is used just once, at one place in all your application, you can cut and paste the body (the instructions) of the code inside the onEvent subroutine.
 
 
Hoping it may help,
Vanderghast, Access MVP
 
"Larry H" <larryh@appliedimage.com> wrote in message news:95rvae$mke$1@nnrp1.deja.com...
> I know how to convert macros to modules. I know that doing so is
> supposed to improve the performance of the database.
>
> What I don't understand is what you are supposed to do after converting
> the macros. I have about 10 of them, and most of them are assigned to
> event procedures, mainly to buttons located on forms.
>
> If I convert these macros to modules, what do I change the "on event"
> procedures to, so that these modules get referenced in lieu of their
> macros?
>
>
> --
> Larry R Harrison Jr
>
>
> Sent via Deja.com
> http://www.deja.com/