flag/trigger

[Cindy]

Hi,

I have a form that tracks software information such as date purchased,
amount and expiry date. I was wondering if there was anyway to flag/trigger
the system to notify me when the expiry date is near. An email if possible
if not any other way. I would like this so that I know when the expiry date
is near and I need to reorder.

Thanks, any help would be appreciated.

 

[Tony Toews]

I have a form that tracks software information such as date purchased,
amount and expiry date. I was wondering if there was anyway to flag/trigger
the system to notify me when the expiry date is near. An email if possible
if not any other way. I would like this so that I know when the expiry date
is near and I need to reorder.

Using VBA code, with a query which looks at the tickler date based on
todays date. I.e. <= Date(), set a flag in those records as "about
to send emails", loop through the recordset to send the emails, update
the flag as "sent emails", and a sent date. Repeat tomorrow.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm