msg box based on time of day

[PeteJM]

(Access 2003)

Hi,

I would like to have a message box pop up from my database.

The problem is that i would like it to pop up at 8pm Monday - Thursday, 2pm Friday and 1pm Saturday. i have a text box on my form that displays the time using the =time() function. I have tried a couple of ways to get this to work but my access skills are just not good enough. I would be happy just to get one of the times to work...

Could anyone help or point me in the direction of an example or tutorial.

Regards

Pete

 

[namliam]

Thats simple enough

In the form use the timer function
Set it to 5000 (milliseconds so that would be 5 secs)
use the "On timer" event to create some code to check the
Weekday(date) = 1....7
datepart("hh") =
and what ever more you want.

Regards