Reminder Notice

[aran]

Hi,

I am building a database for a colleague. He wants the
database to "flash up" a reminder afetr a certain number
of weeks. For example when he sends a letter out through
the database the date is recorded, then if the user does
select a certain box ie. "reply received" before 8 weeks
the computer warns the user that it has been eight weeks
and its time to chase the person up. Is this possible, I
am very new to access so any help would be grateful.

Many Thanks

Aran

 

[Irvin Amoraal]

Hi aran,
Yes I think it is possible, although I don't have the time to code it for
you.
I would look at using a form event (on the form's property box) like "on
open" or "on load" to fire up a script. The script would create a recordset
of all mailings that have a date eight days less than the current date. I
would also use a "snooze" option to allow the remider to stay dormant for a
period of time or days. You would also need a method to turn off the
reminder for that item if there is no response at all.

Hope this helps.
Irvin. <><
_____________________________________