javajom Javajon Local time Today, 22:57 Joined Mar 5, 2008 Messages 37 Mar 8, 2008 #1 Hi, I need to activate a message box on a certain date, I've tried the excel code: PHP: If Date <= DateSerial(2009, 1, 30) Then MsgBox("Hello") End If and I need to start it automatically, AutoExec but not sure how to do it.
Hi, I need to activate a message box on a certain date, I've tried the excel code: PHP: If Date <= DateSerial(2009, 1, 30) Then MsgBox("Hello") End If and I need to start it automatically, AutoExec but not sure how to do it.
W WayneRyan AWF VIP Local time Today, 22:57 Joined Nov 19, 2002 Messages 7,122 Mar 8, 2008 #2 JJ, There are quite a few ways to do this. You can put the code in a Public Function or Sub and trigger it with a Macro called AUTOEXEC. I'd use the open event of the main form of your database and just pop that code in it. Wayne
JJ, There are quite a few ways to do this. You can put the code in a Public Function or Sub and trigger it with a Macro called AUTOEXEC. I'd use the open event of the main form of your database and just pop that code in it. Wayne
