Due Date reminder or such

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

Hello
I have a form that has a date field that the users can enter a date in the
future for a follow up with Clients.

So that the user doesn't have to go into each record to check the 'due date'
I've created a form that they open which lists all the clients and the 'due
date' field is sorted.

But does anyone have a suggestion for a better way?
For example, can it be linked to Outlook in some way to schedule a reminder?
or is that pie in the sky? Or can Access have it's own Calendar form?
Thank you
Jenny
(Office 03)
 
Scheduling a reminder in Outlook is certainly possible but requires
good understanding of VBA and the Outlook object model. There are also
pitfalls such as the security warnings in Outlook to overcome. Perhaps
more than you want to do right now.
With Docmd.SendObject you can write 1 line of code and email the user
a report with a list of all accounts close to the due date.

-Tom.
Microsoft Access MVP
 
I'm guessing that the reminder to outlook or any specific reminder will
require the query or dates to be updated regularly by me.
So I think the simplest would be a calendar Jeff suggested as that could be
seen at a glance and the user would be responsible to check it daily.
Is that hard to do?
Jen
 
Back
Top