DateDiff(), I cant figure it out

  • Thread starter Thread starter bern
  • Start date Start date
B

bern

Hi,

I want to make access alert me when I am approching a
certain date. I have made a query that selects all posts
that has less than 21 days till the due date using the
datediff() function. What i really would like to know is
how I can make access alert me with a msgbox or something
telling me that the deadline-date is approaching. It's
like, when I load the main form, I want the form to run
the query and check if it has any values and alert me if
it has (if it does not have any, there are no deadline-
date within the next 21 days). How can I do this, or are
there any other (smarter) ways to do this?

Thanks a lot

cheers.
 
Back
Top