Due Date reminder or such

[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)

 

[Jeff Boyce]

Jenny

You'll need to define what you want a bit clearer. Are you more interested
in a "calendar" with due dates showing, or having a way to know which due
dates fall in the next "week"/"month"/(you pick a time frame)?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Tom van Stiphout]

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

 

[JB]

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