Setting reminders

K

Kate123

I am using Access to keep track of contacts that I call and sometimes need to
call back at a certain time or day. Is there some way to set a reminder as
you would do in a calender, or some other way that I can easily know who I
need to call any given week without going into each individual contact and
looking at what I've written in the calls?
 
K

KARL DEWEY

You can use a table, query, form, and Autoexec macro.
The table needs at a minimum Contact, Suspense (date), Remarks (Text or
memo), Done (Yes/No) fields.
The query is a select with criteria of Date()+5 (or however many days before
you want prompted) and 0 (zero for the Done field).
The macro will open the form every time the database is opened.
 
Top