Reminders

  • Thread starter Thread starter mikeinohio
  • Start date Start date
M

mikeinohio

I have a question on how to do a reminder, i have a table that has the
following colunms in it

name
start date
recert date1
recert date 2
recert date3

the first recert date occurs in 56 days and must be completed before the
60th day.

the second recert date occurs in 116 days and must be completed before the
120th day.

the third recert date occurs in 176 days and must be completed before the
180th day.

how can i set up a reminder by way of a pop up when the record is opened
that will notify the user within 10 days of the 56th, 116th and 176th day and
on the 60th, 120th, and 180th if its not checked completed day it will make
the record not accessable for editing.

also is there a way to run a query when the databaes is open to
automatically life in a window all of the records that are needed to be
recertified in case a particular record is not opened?
 
You can run a query but it would probably be better to run a form based on
that query when your database opens.
Use conditional formatting to show what you want.
Store only the start date and your query would have
recert date1: DateAdd("d",56,[start date])
recert date2: DateAdd("d",116,[start date])
recert date3: DateAdd("d",176,[start date])
When you build the form conditional formatting for date 1 would be
Values between Date() and DateAdd("d",10,Date())
I use yellow for an app that I use this in.
A second condition is where the value is less than the date. I use red for
that as the card has expired.
 
Back
Top