Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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"
    >>> >

    >>

    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page