Can I make Access send a flag when a date field is nearing?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a database that will send up a flag - to my email, to
another database, etc when a date field (a due date) is nearing.
Can this be done?
Or should I just monthly (periodically) run a report that will show when
everything is due?

Thanks
 
Hi,

The way I would go about this you need database to be running that has the
events in it, create a form, make sure the form is running all the time,
maybe a hidden form, on the timer event for the form, process every x
minutes 60,000 milliseconds per minute, to process the table with the events
in it, anything passing the date and time, run a process popup, report,
email, network alert.

I use the above for a calendaring and scheduling solution and works very
well, but it does need to be running 24x7 if that is the type of resolution
you require. If you just need to find out things that should have happened
yesterday then just run it once a day.
 
You could build some code that allows Access to create & manage tasks in
Outlook. The code would execute when the DB is opened to update the tasks.
 
Is there somewhere I can learn how to do this coding? I have a reference
book but it is not nearly this advanced. This sounds like the option I am
looking for.

Thanks
 
Back
Top