Send email when date passed

[wtrimble]

Is there anyway to trigger a cell date or date field that when the date has passed that it will send an email letting the user know that a certain field's due date is late, whether or not the database is open?

I was looking through the events and couldn't think of a way to do it, if it is possible at all.

Any help would be greatly appreciated!

Thanks.

 

[Trevor G]

In the control panel of your desktop you have a scheduler, you can add a time event to open the database and run a macro even if the database isn't open, you would need to have the pc switched on though, either that or use a server script to do the same.

If you look at the scheduler on the desktop there is enough help there to get you to the place you need to be.

 

[wtrimble]

Yes seems like a good idea. However if I created some VB to run on Load, this would occur everytime the Database was open, either by the user or by the scheduler. I would want to close the database if there are no "violations", but not if the user opened the database.

Any thoughts?

 

[Trevor G]

rather than on load, what about a hidden form with an on timer event as the additional trigger?

 

[wtrimble]

Yes that would work, but my problem is that I would want the database to close if the scheduled event opened the database and there were no violations. I don't want the database to close if the user opened the database and there were no violations.

 

[wtrimble]

Maybe there's a better solution than having the program open and run at a certain scheduled event??

 

[Trevor G]

How about setting up a table which allocates permission and then redirect the main group of users to a start form which is different to the on load event form, then allocate a user in the table to be allowed permission to go to that form, everything could be a mirrow image except that one person (or maybe a few go to a different front screen).

Have a look at the attached security sample, if you look at the table behind it you will see it is using some different levels and dlookup in the code screen to force the database on open to move them to the correct form.

 

[wtrimble]

Thanks, I'll take a look at it.