Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Assign Module to Command Button

Discussion in 'Information Technology' started by Andibevan, Nov 10, 2005.

  1. Andibevan

    Andibevan
    Expand Collapse
    Guest

    Hi All,

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

    Thanks

    Andy
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Sikh diaspora condemn Bhutto's assignation (ANI via Yahoo! India News) Breaking News Dec 28, 2007
    Sikh News Punjab & Sind Bank assigned A1+ for Rs 1,000 cr deposit prog (Deepika) Breaking News Oct 17, 2007

  3. Dean

    Dean
    Expand Collapse
    Guest

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

    "Andibevan" <Andibevan@notehere-hotmail.com> 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. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    And you do that through the properties associated with the Command Button.

    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" <deanl144@hotmail.com.nospam> 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" <Andibevan@notehere-hotmail.com> 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
    > >
    > >

    >
    >
     
  5. Andibevan

    Andibevan
    Expand Collapse
    Guest

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

    "Dean" <deanl144@hotmail.com.nospam> 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" <Andibevan@notehere-hotmail.com> 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
    > >
    > >

    >
    >
     
  6. Andibevan

    Andibevan
    Expand Collapse
    Guest

    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" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:O04i1cT5FHA.3544@TK2MSFTNGP09.phx.gbl...
    > And you do that through the properties associated with the Command Button.
    >
    > 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" <deanl144@hotmail.com.nospam> 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" <Andibevan@notehere-hotmail.com> 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
    > > >
    > > >

    > >
    > >

    >
    >
     

Share This Page