Pop-up message macros
Pop-up message macros
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Pop-up message macros

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Northampton, UK
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I'm designing a booking system and have created a macro to clear the form so it's ready for the next data entry. The problem is the booking needs to be printed and added to the database from the form first. What i'm wondering is how would i get a pop up message which reminds the user of this where it is possible for an "OK" and a "cancel" style option. At the moment all that happens is the message pops-up asking if the booking has been saved and added and the user can only click ok which will then clear the form regardless of whether it's been added or printed.
    Copy of what i'm using at the moment is below:

    MsgBox "Have You Printed and added this booking before clearing?", vbInformation
    Thanx for any help, BEX

  2. #2
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey Beckwa, perhaps the code below will help:

    Select Case MsgBox("Have You Printed and added this booking before clearing?", vbYesNo)
    Case vbYes
    'your code
    Case vbNo
    'your code
    End Select


    Hope so. Cheers,

    Nate

    [ This Message was edited by: NateO on 2002-03-13 12:07 ]

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Northampton, UK
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you very much for your help!!! It worked really well
    Bex

  4. #4
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Nice Bex.

    [ This Message was edited by: NateO on 2002-03-13 12:53 ]

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Could you please explain more? How to "Select Case MsgBox("Have You Printed and added this booking before clearing?", vbYesNo) "

    Thanks

  6. #6
    New Member
    Join Date
    Mar 2002
    Location
    Northampton, UK
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Lol u show off!!
    BEX

  7. #7
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Bex, me, showing off? Three good smileys deserve some more (as I always say)!

    I can certainly explain more WYTT, what would you like to know?

    Cheers y'all,

    Nate

    [ This Message was edited by: NateO on 2002-03-13 15:20 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com