Set up a Reminder

  • Thread starter Thread starter Brown
  • Start date Start date
B

Brown

I have a database for a document library. I need to generate reminders when
documents are almost due, and a separate reminder/tickler when the document
is past due.
Is there a good resource for this type requirement? I assume a query that
would run at database startup would probably but the best approach.
Any suggestions welcome.

Brown
 
Hi,


You can indeed set a record with the date and time due (where the
"message" is due to be presented to the end user, not the job described by
the message itself). Under a from timer (the form may be invisible) set with
an interval of 1 minute (or more, Access allows more that 64000 millisec for
the timer interval), check :


if 0 <> DCount("*", MyTable, "DateDue<Now()" ) then
Me.TimerInterval = 0 ' disable it
MsgBox "hey boss, you asked me to prompt you about... "
& ...
' part of the process is to either remove the record
WHERE DateDue<Now()
' or to update to another DateDue value
...
Me.TimerInterval = 60000 ' re-enable it
end If



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top