var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Send an Email if Due date is Approching
Having problems and wondering if it is possible within VBA or does it need to be completed through a query and if so How
I have a form "nominalregister" with a Relationship to a Table "tblnominal"
One of the Feilds is "Valid To" which is a date format
What I would like to do is send an email to warn that the due date for renewal is required 90 days prior
I am thinking that on load on the first navigational form when access loads so that it is checked regularly
You need an expression like: If [Valid To] - 90 = Date() Then SendMail() to validate the [Valid To] Field value and run the Mail Sending procedure in VBA.
Check the following link and other references in that page to get some idea:
Automated E-Mail Alerts.
(Learn MS-Access Tips & Tricks)
Learn Advanced MS-Access Programming with sample VBA Code.
All responses are based on Access 2003/2007