Automate Reminder in Access Database

  • Thread starter Thread starter Thang On
  • Start date Start date
T

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.
 
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.
 
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.

.
Click to expand...
 
Back
Top