Reminder for a date field

R

Roberta

I need a reminder based on a due date in an Access form. How can I
accomplish this? For example, 3 days before due date I like to get a reminder
about that particular customer or task listed in the form.
 
S

Sreedhar

Hi,
Roberta said:
I need a reminder based on a due date in an Access form. How can I
accomplish this? For example, 3 days before due date I like to get a reminder
about that particular customer or task listed in the form.
Click to expand...

Here is a rough sketch of things to do:

1) You need to design a form to show whatever you want to remind.

2) Use DCount to count the events that need to be reminded based on the
dates. The following untested code just gives you pointers, you may want to
modify and adopt:

Sub ShowReminder()
Dim intTopic As Integer
intTopic=DCount("Topic", "tblWhereDateValueStored", "FollowUpDate =
DateAdd("d", -3, Date)")
If intTopic > 0 Then DoCmd.OpenForm "frmReminder"
End Sub
3) You can execute the above code from an AutoExec's RunCode Action to fire
the Reminder form as soon as the db is opened.

This only a skeleton. You can take on from here on.
 
S

Sreedhar

RunCode action runs only functions.

Hence, "Sub ShowReminder" should be "Function ShowReminder". Sorry for the
slip in my first post.
 
Top