S Shazz Registered User. Local time Today, 01:57 Joined Oct 14, 2008 Messages 53 Jan 5, 2009 #1 Hi everyone, I would like to put a Pop up Box in my database that pops up with a message on a certain date, can anyone help me with this? Happy New Year to you all. Shazz
Hi everyone, I would like to put a Pop up Box in my database that pops up with a message on a certain date, can anyone help me with this? Happy New Year to you all. Shazz
N namliam The Mailman - AWF VIP Local time Today, 10:57 Joined Aug 11, 2003 Messages 11,695 Jan 5, 2009 #2 Code: If date() = #01/Jan/2010# then msgbox "Happy Newyear!" end if Something like that?
S Shazz Registered User. Local time Today, 01:57 Joined Oct 14, 2008 Messages 53 Jan 5, 2009 #3 Thanks for your reply, but where do I put this code, I am very new this Access, I know how to create a pop up box but that is my limit. Shazz
Thanks for your reply, but where do I put this code, I am very new this Access, I know how to create a pop up box but that is my limit. Shazz
N namliam The Mailman - AWF VIP Local time Today, 10:57 Joined Aug 11, 2003 Messages 11,695 Jan 6, 2009 #4 Anywhere where you would want the popup box... where would you stick your box if you want it? Exactly on that spot!
Anywhere where you would want the popup box... where would you stick your box if you want it? Exactly on that spot!
S Shazz Registered User. Local time Today, 01:57 Joined Oct 14, 2008 Messages 53 Jan 6, 2009 #5 I only want it to pop up on a particular date, so if I put the code in the form, will it just pop up on that date, or will it pop up everytime I open it. Shaz
I only want it to pop up on a particular date, so if I put the code in the form, will it just pop up on that date, or will it pop up everytime I open it. Shaz
Dennisk AWF VIP Local time Today, 09:57 Joined Jul 22, 2004 Messages 1,649 Jan 6, 2009 #6 Create a macro called Autoexec and call a module function that contains the code. any macro call 'Autoexec' will be executed every time the db is opened.
Create a macro called Autoexec and call a module function that contains the code. any macro call 'Autoexec' will be executed every time the db is opened.