Assign Module to Command Button

#1 (**permalink**) 10-Nov-2005, 21:08 PM

Hi All,

Can someone tell me how I assign a module to a command button?

Thanks

Andy
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6997-assign-module-to-command-button.html

*

#2 (**permalink**) 10-Nov-2005, 21:08 PM

You don't assign modules, you assign a function or subroutine within a
module.

"Andibevan" wrote in message
news:%23Dx1$1S5FHA.884@TK2MSFTNGP14.phx.gbl...
> Hi All,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6997
>
> Can someone tell me how I assign a module to a command button?
>
> Thanks
>
> Andy
>
>

#3 (**permalink**) 10-Nov-2005, 21:08 PM

And you do that through the properties associated with the Command Button.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6997
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6997

If you have a function that you want run when the command button is clicked,
for instance, you would put the name of the function (complete with
parentheses), with an equal sign in front, in the box on the property sheet
beside On Click.

More common, though, is to set that property to [Event Procedure] (select it
from the combo box) and then click on the ellipsis (...) to the right. That
will take you into the VB Editor, into the Event Procedure associated with
the Click event of the button.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Dean" wrote in message
news:eZ7%23s4S5FHA.1148@TK2MSFTNGP10.phx.gbl...
> You don't assign modules, you assign a function or subroutine within a
> module.
>
> "Andibevan" wrote in message
> news:%23Dx1$1S5FHA.884@TK2MSFTNGP14.phx.gbl...
> > Hi All,
> >
> > Can someone tell me how I assign a module to a command button?
> >
> > Thanks
> >
> > Andy
> >
> >
>
>

#4 (**permalink**) 10-Nov-2005, 21:08 PM

Sorry - I mean how do I assign a subroutine contained within a module to a
command button?

"Dean" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6997
news:eZ7%23s4S5FHA.1148@TK2MSFTNGP10.phx.gbl...
> You don't assign modules, you assign a function or subroutine within a
> module.
>
> "Andibevan" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6997
> news:%23Dx1$1S5FHA.884@TK2MSFTNGP14.phx.gbl...
> > Hi All,
> >
> > Can someone tell me how I assign a module to a command button?
> >
> > Thanks
> >
> > Andy
> >
> >
>
>

#5 (**permalink**) 10-Nov-2005, 21:08 PM

Thanks Doug - sometimes trying to find information on the really easy things
can be harder than finding info on more in-depth items.

Please ignore the mail I sent before I received your reply.

"Douglas J Steele" wrote in message
news:O04i1cT5FHA.3544@TK2MSFTNGP09.phx.gbl...
> And you do that through the properties associated with the Command Button.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6997
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6997
>
> If you have a function that you want run when the command button is
clicked,
> for instance, you would put the name of the function (complete with
> parentheses), with an equal sign in front, in the box on the property
sheet
> beside On Click.
>
> More common, though, is to set that property to [Event Procedure] (select
it
> from the combo box) and then click on the ellipsis (...) to the right.
That
> will take you into the VB Editor, into the Event Procedure associated with
> the Click event of the button.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Dean" wrote in message
> news:eZ7%23s4S5FHA.1148@TK2MSFTNGP10.phx.gbl...
> > You don't assign modules, you assign a function or subroutine within a
> > module.
> >
> > "Andibevan" wrote in message
> > news:%23Dx1$1S5FHA.884@TK2MSFTNGP14.phx.gbl...
> > > Hi All,
> > >
> > > Can someone tell me how I assign a module to a command button?
> > >
> > > Thanks
> > >
> > > Andy
> > >
> > >
> >
> >
>
>