Automate Reminder in Access Database

[Thang On]

I would like to automate notification reminder in access
at certain time i.e 12:00 p.m. and 3:00 p.m by using
system time. I don't want to use outlook and I don't want
to activate any button in access to call that procedure.
Could anyone please help me. Thanks.

 

[Robert taylor]

Make a hidden form with a timer event on it that
periodically checks the system time (I would make it check
every 30 seconds or so). When it reaches the desired
system time have it open a popup form with the reminder
you want. I would also have a boolean value in a table
somewhere to indicate the box popped up at a given time so
it doesnt pop up more than once.

 

[Guest]

Thank you so much Robert, it's a great hint.

-----Original Message-----
Make a hidden form with a timer event on it that
periodically checks the system time (I would make it check
every 30 seconds or so). When it reaches the desired
system time have it open a popup form with the reminder
you want. I would also have a boolean value in a table
somewhere to indicate the box popped up at a given time so
it doesnt pop up more than once.

.