Can Access be used to do this?

[Bilbo1161]

Hi
I have created an Access DB for maintaining our contractors information.

It has a few tables for CompanyDetails, ContractorsDetails and Attendance.

Part of the CompanyDetails table, is to hold the Public Liability Insurance expiry date. To enable us to ensure this is always in date.

When a contractor comes to site, a button is used on a form to add this attendance into the attendance table and modify the last time on site field.

What I want to happen, is when this button is pressed, as well as doing the above, it checks the last time on site date against the insurance expiry date and if the expiry date is less than the last time on site date it sends me an email telling me that the contractor is on site and his Public Liability Insurance is invalid.

I think this is possible by setting a temp variable, but not sure how this would then email me the above details.

Thanks for your help in advance

 

[Pat Hartman]

Can Access be used to do this?

Yes. No TempVar is required. Use a query to determine if the insurance is still active. I'm sure if you search the site, you'll find examples of sending email.