View Full Version : date


javajom
03-08-2008, 09:10 AM
Hi,
I need to activate a message box on a certain date, I've tried the excel code:

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.

WayneRyan
03-08-2008, 10:06 AM
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