Pop-up message macros

Beckwa · Mar 13th, 2002, 12:58 PM

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

NateO · Mar 13th, 2002, 01:03 PM

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 ]

Beckwa · Mar 13th, 2002, 01:41 PM

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

Bex

NateO · Mar 13th, 2002, 01:53 PM

Nice Bex.

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

WYTT · Mar 13th, 2002, 02:25 PM

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

Thanks

Beckwa · Mar 13th, 2002, 02:25 PM

Lol u show off!!
BEX

NateO · Mar 13th, 2002, 04:19 PM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 12:58 PM	#1
Beckwa New Member Join Date: Mar 2002 Location: Northampton, UK Posts: 33	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

Mar 13th, 2002, 01:03 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	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 ]

Mar 13th, 2002, 01:41 PM	#3
Beckwa New Member Join Date: Mar 2002 Location: Northampton, UK Posts: 33	Thank you very much for your help!!! It worked really well Bex

Mar 13th, 2002, 01:53 PM	#4
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Nice Bex. [ This Message was edited by: NateO on 2002-03-13 12:53 ]

Mar 13th, 2002, 02:25 PM	#5
WYTT New Member Join Date: Mar 2002 Posts: 13	Could you please explain more? How to "Select Case MsgBox("Have You Printed and added this booking before clearing?", vbYesNo) " Thanks

Mar 13th, 2002, 04:19 PM	#7
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	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 ]