Welcome to SPN

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

Sign Up Now!

After Update Question

Discussion in 'Information Technology' started by Bob, Jul 28, 2006.

  1. Bob

    Bob
    Expand Collapse
    Guest

    I have a Combo Box that has 3 options in it about tax , Can I add a Message
    box to warn about something , so you click OK and carry on selecting your
    choice, There is nothing On Click just After Update

    Thanks in advance.........Bob Vance
     
  2. Loading...


  3. Sarah Schreffler

    Sarah Schreffler
    Expand Collapse
    Guest

    Bob wrote:
    > I have a Combo Box that has 3 options in it about tax , Can I add a Message
    > box to warn about something , so you click OK and carry on selecting your
    > choice, There is nothing On Click just After Update
    >
    > Thanks in advance.........Bob Vance


    If you want the Msgbox to offer the option NOT to select the option,
    then you want BeforeUpdate instead. (That can be cancelled)

    AfterUpdate fires after the choice is made.

    Sarah Schreffler
     
  4. Bob

    Bob
    Expand Collapse
    Guest

    No just wanted to give them a warning when they click on the arrow but still
    proceed...Thanx Bob
    OK Warning that they have read it!

    "Sarah Schreffler" <sarah.schreffler@gmail.com> wrote in message
    news:1150952884.466518.190440@m73g2000cwd.googlegroups.com...
    >
    > Bob wrote:
    >> I have a Combo Box that has 3 options in it about tax , Can I add a
    >> Message
    >> box to warn about something , so you click OK and carry on selecting your
    >> choice, There is nothing On Click just After Update
    >>
    >> Thanks in advance.........Bob Vance

    >
    > If you want the Msgbox to offer the option NOT to select the option,
    > then you want BeforeUpdate instead. (That can be cancelled)
    >
    > AfterUpdate fires after the choice is made.
    >
    > Sarah Schreffler
    >
     
  5. Svetlana

    Svetlana
    Expand Collapse
    Guest

    You could raise up the msg box you want on mouse down event for the
    combobox.
     
  6. Bob

    Bob
    Expand Collapse
    Guest

    Could you alter this message so it works...Thanx Bob

    Private Sub cbGSTOptions_MouseDown(Button As Integer, Shift As Integer, X As
    Single, Y As Single)
    "Please Update Your Tax Button"
    End Sub

    "Svetlana" <AccessMindMe@yahoo.com> wrote in message
    news:1150955265.335411.38260@p79g2000cwp.googlegroups.com...
    > You could raise up the msg box you want on mouse down event for the
    > combobox.
    >
     
  7. Sarah Schreffler

    Sarah Schreffler
    Expand Collapse
    Guest

    Bob wrote:
    > Could you alter this message so it works...Thanx Bob
    >
    > Private Sub cbGSTOptions_MouseDown(Button As Integer, Shift As Integer, X As
    > Single, Y As Single)
    > "Please Update Your Tax Button"
    > End Sub
    >
    > "Svetlana" <AccessMindMe@yahoo.com> wrote in message
    > news:1150955265.335411.38260@p79g2000cwp.googlegroups.com...
    > > You could raise up the msg box you want on mouse down event for the
    > > combobox.


    Okay, BeforeUpdate and AfterUpdate doesn't fire until after they have
    made a choice in Combo Box.

    In order to pop up a MSgbox you need to use the command.

    Msgbox "Please Update Your Tax Button"
     
  8. Bob

    Bob
    Expand Collapse
    Guest

    Thanx Sarah worked brilliant....Access doesn't have a Mouse over message
    does it , Cursor over box and a message pops up.....Thanks bob

    "Sarah Schreffler" <sarah.schreffler@gmail.com> wrote in message
    news:1150983057.710393.240680@y41g2000cwy.googlegroups.com...
    >
    > Bob wrote:
    >> Could you alter this message so it works...Thanx Bob
    >>
    >> Private Sub cbGSTOptions_MouseDown(Button As Integer, Shift As Integer, X
    >> As
    >> Single, Y As Single)
    >> "Please Update Your Tax Button"
    >> End Sub
    >>
    >> "Svetlana" <AccessMindMe@yahoo.com> wrote in message
    >> news:1150955265.335411.38260@p79g2000cwp.googlegroups.com...
    >> > You could raise up the msg box you want on mouse down event for the
    >> > combobox.

    >
    > Okay, BeforeUpdate and AfterUpdate doesn't fire until after they have
    > made a choice in Combo Box.
    >
    > In order to pop up a MSgbox you need to use the command.
    >
    > Msgbox "Please Update Your Tax Button"
    >
     
  9. Sarah Schreffler

    Sarah Schreffler
    Expand Collapse
    Guest

    Not a Mouse Over message.
    But the ComboBox (in Access 2003) DOES have a OnMouseMove event. II
    have not worked with it (didn't even know it was there until you asked
    and I went to look) You might take a look at the help on that and see
    if it would suit.

    The way Access generally works (like Visual Basic) is actions
    triggering events. Then you can write code (or macros but generally
    VBA code is a better idea, more flexible, ability to step through the
    code to find errors and catch errors gracefully) to run when an event
    is trigger. For example, changing the status line or popping up a
    message box when the mouse moves over a particular control :)

    Sarah Schreffler

    Bob wrote:
    > Thanx Sarah worked brilliant....Access doesn't have a Mouse over message
    > does it , Cursor over box and a message pops up.....Thanks bob
    >
    > "Sarah Schreffler" <sarah.schreffler@gmail.com> wrote in message
    > news:1150983057.710393.240680@y41g2000cwy.googlegroups.com...
    > >
    > > Bob wrote:
    > >> Could you alter this message so it works...Thanx Bob
    > >>
    > >> Private Sub cbGSTOptions_MouseDown(Button As Integer, Shift As Integer, X
    > >> As
    > >> Single, Y As Single)
    > >> "Please Update Your Tax Button"
    > >> End Sub
    > >>
    > >> "Svetlana" <AccessMindMe@yahoo.com> wrote in message
    > >> news:1150955265.335411.38260@p79g2000cwp.googlegroups.com...
    > >> > You could raise up the msg box you want on mouse down event for the
    > >> > combobox.

    > >
    > > Okay, BeforeUpdate and AfterUpdate doesn't fire until after they have
    > > made a choice in Combo Box.
    > >
    > > In order to pop up a MSgbox you need to use the command.
    > >
    > > Msgbox "Please Update Your Tax Button"
    > >
     
  10. Bob

    Bob
    Expand Collapse
    Guest

    What have I done wrong here, I want to show this message:
    Private Sub tbCompanyName_MouseMove(Button As Integer, Shift As Integer, X
    As Single, Y As Single)
    Msgbox(This is a Company Name Box)
    End Sub

    "Sarah Schreffler" <sarah.schreffler@gmail.com> wrote in message
    news:1151076999.757901.171780@i40g2000cwc.googlegroups.com...
    > Not a Mouse Over message.
    > But the ComboBox (in Access 2003) DOES have a OnMouseMove event. II
    > have not worked with it (didn't even know it was there until you asked
    > and I went to look) You might take a look at the help on that and see
    > if it would suit.
    >
    > The way Access generally works (like Visual Basic) is actions
    > triggering events. Then you can write code (or macros but generally
    > VBA code is a better idea, more flexible, ability to step through the
    > code to find errors and catch errors gracefully) to run when an event
    > is trigger. For example, changing the status line or popping up a
    > message box when the mouse moves over a particular control :)
    >
    > Sarah Schreffler
    >
    > Bob wrote:
    >> Thanx Sarah worked brilliant....Access doesn't have a Mouse over message
    >> does it , Cursor over box and a message pops up.....Thanks bob
    >>
    >> "Sarah Schreffler" <sarah.schreffler@gmail.com> wrote in message
    >> news:1150983057.710393.240680@y41g2000cwy.googlegroups.com...
    >> >
    >> > Bob wrote:
    >> >> Could you alter this message so it works...Thanx Bob
    >> >>
    >> >> Private Sub cbGSTOptions_MouseDown(Button As Integer, Shift As
    >> >> Integer, X
    >> >> As
    >> >> Single, Y As Single)
    >> >> "Please Update Your Tax Button"
    >> >> End Sub
    >> >>
    >> >> "Svetlana" <AccessMindMe@yahoo.com> wrote in message
    >> >> news:1150955265.335411.38260@p79g2000cwp.googlegroups.com...
    >> >> > You could raise up the msg box you want on mouse down event for the
    >> >> > combobox.
    >> >
    >> > Okay, BeforeUpdate and AfterUpdate doesn't fire until after they have
    >> > made a choice in Combo Box.
    >> >
    >> > In order to pop up a MSgbox you need to use the command.
    >> >
    >> > Msgbox "Please Update Your Tax Button"
    >> >

    >
     
  11. Bob

    Bob
    Expand Collapse
    Guest

    I am Stupid
    Msgbox("This is a Company Name Box")

    "Bob" <xxx@xx.xx> wrote in message news:e7kg0g$tfa$1@lust.ihug.co.nz...
    > What have I done wrong here, I want to show this message:
    > Private Sub tbCompanyName_MouseMove(Button As Integer, Shift As Integer, X
    > As Single, Y As Single)
    > Msgbox(This is a Company Name Box)
    > End Sub
    >
    > "Sarah Schreffler" <sarah.schreffler@gmail.com> wrote in message
    > news:1151076999.757901.171780@i40g2000cwc.googlegroups.com...
    >> Not a Mouse Over message.
    >> But the ComboBox (in Access 2003) DOES have a OnMouseMove event. II
    >> have not worked with it (didn't even know it was there until you asked
    >> and I went to look) You might take a look at the help on that and see
    >> if it would suit.
    >>
    >> The way Access generally works (like Visual Basic) is actions
    >> triggering events. Then you can write code (or macros but generally
    >> VBA code is a better idea, more flexible, ability to step through the
    >> code to find errors and catch errors gracefully) to run when an event
    >> is trigger. For example, changing the status line or popping up a
    >> message box when the mouse moves over a particular control :)
    >>
    >> Sarah Schreffler
    >>
    >> Bob wrote:
    >>> Thanx Sarah worked brilliant....Access doesn't have a Mouse over message
    >>> does it , Cursor over box and a message pops up.....Thanks bob
    >>>
    >>> "Sarah Schreffler" <sarah.schreffler@gmail.com> wrote in message
    >>> news:1150983057.710393.240680@y41g2000cwy.googlegroups.com...
    >>> >
    >>> > Bob wrote:
    >>> >> Could you alter this message so it works...Thanx Bob
    >>> >>
    >>> >> Private Sub cbGSTOptions_MouseDown(Button As Integer, Shift As
    >>> >> Integer, X
    >>> >> As
    >>> >> Single, Y As Single)
    >>> >> "Please Update Your Tax Button"
    >>> >> End Sub
    >>> >>
    >>> >> "Svetlana" <AccessMindMe@yahoo.com> wrote in message
    >>> >> news:1150955265.335411.38260@p79g2000cwp.googlegroups.com...
    >>> >> > You could raise up the msg box you want on mouse down event for the
    >>> >> > combobox.
    >>> >
    >>> > Okay, BeforeUpdate and AfterUpdate doesn't fire until after they have
    >>> > made a choice in Combo Box.
    >>> >
    >>> > In order to pop up a MSgbox you need to use the command.
    >>> >
    >>> > Msgbox "Please Update Your Tax Button"
    >>> >

    >>

    >
    >
     

Share This Page