Stupid Question...

[XelaIrodavlas]

Hi all,

This is probably a stupid question so I'll keep it short and sweet. Is there any way access can send an email (based on when a field date expires) when Access itself hasn't even been opened?

I've been asked to set up a reminder system but they don't want to have to check in every day to find out.. Is there a better MS tool that might do this job?

Thanks!

 

[DavidAtWork]

How is this field date stored, is it stored in a table or is it just a calculated date field on a form. If the field date you want to check only exists on a form in the database, then you'll need to open the database and write something that will be triggered by the field date expiring OR if stored in a table you could have another application linked to the table that table, ie Excel, but you'd still have to open Excel to trigger the event.
You can create a Windows scheduled task on a server that will open the database and you could write a function that will check the field date (from wherever the value will come) and if expired, create and send an email, perhaps record whether an email was sent in some kind of log table and afterwards close the file and Kill Access. This can all be automated without the need for anybody to manually open the database
David

 

[XelaIrodavlas]

Thanks David that's pretty much what I thought. You've given me a lot to think about, but given the complexity of what you suggest and the relative simplicity and small-scale of what this database is, I think my solution is simple. I tell any lazy bones to check it themselves