I have a screen that has 8 different buttons and clicking on any of these button generates an appropriate letter and once the button was clicked in also inserts a date, today's date.

Private Sub btnSecondReport_Click()
On Error GoTo Err_btnSecondReport_Click

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
'* Call the standard letter printing routine for this form.

Call StandardLetterVariables("Bd$50paid.doc")

[DTSecondLetterSent] = Date

Exit Sub

MsgBox Err.Description
Resume Exit_btnSecondReport_Click

So I would like to create an alert that looks at this date and 14 days from that date will alert, remind whatever I want to do.
I am thinking it wouldn't be too hard to create a reminder that pops up when the record is opened but I am sure users will want to be reminded without having to go into the record.

My question: can I and is it hard to create a reminder that will take care of paying attention when and who needs to be reminded or should I just create a report and let them run this.

I hope this makes sense and sombody has done this.