Adding a year to a date entered and getting a reminder when date is almost reached

  • Thread starter Thread starter emanuel.levy
  • Start date Start date
E

emanuel.levy

I have to keep track of renewals of a certification. I have a table
with the following fields

Employer
Certification_Start_Date
Certification_Request_Number


All certifications last for One Year so I need to display in the Form
that is used to enter the data the Expiration Date which would be (
Certification_start_date + 365 ) And I don't know if that can be done
or how to do it.

I also need to have a report? give a reminder when there is 95 then 65
days from the end of the certification.

All help would be appreciated.
 
Check Access HELP for the DATEADD function.
You will probaly have to cater for a certification starting on Feb 29th.

Dorian
 
ExpireDate = DateAdd("yyyy", 1, Certification_Start_Date)
FirstWarnDate = DateAdd("d", -95, ExpireDate)
SecondWarnDate = DateAdd("d", -65, ExpireDate)
 
I have to keep track of renewals of a certification. I have a table
with the following fields

Employer
Certification_Start_Date
Certification_Request_Number


All certifications last for One Year so I need to display in the Form
that is used to enter the data the Expiration Date which would be (
Certification_start_date + 365 ) And I don't know if that can be done
or how to do it.
Click to expand...

Put a textbox on the form with a Control Source

=DateAdd("yyyy", 1, [Certification_Start_Date])
I also need to have a report? give a reminder when there is 95 then 65
days from the end of the certification.
Click to expand...

Create a qeury with a criterion on [Certification_Start_Date] such as

< DateAdd("d", -270, Date())

for the 95 days, -300 for the 65 days. It'll be a day out in leap
years but close enough. Your Startup form can check to see if this
query returns any records and pop up a form displaying them if so.

John W. Vinson[MVP]
 
Back
Top