Date Expiry Warning

[Cameron]

Can a warning message be dispayed when a date in a
specific column has expired. Can this be extended to
dispalay a message when a date is one month from expiry.
Is it possible to send an expiry warning in the form of
an e-mail from a DB.

Would appreciate any help.

 

[Peter Kaufman]

You would have to open a recordset on a recurring basis - either on a
timed schedule or every time a database or certain form is opened. Use
a query with a parameter built on the datediff function to only return
records if they met your criteria. If records are returned, then you
send the email.

For assistance on the email automation aspect checkout "sendobject" in
the help system.

Peter