ALARMS ON DUE DATE?

  • Thread starter Thread starter FARAZ QURESHI
  • Start date Start date
F

FARAZ QURESHI

In one of my customers' record I have a field of date of payment. What would
be the means to receive an alarm/popup alert on 9 am of the due date?
 
There's a bit more to it than that.

If the database is not open at 9 am, it's not going to display anything. If
you open it at 9:05, you've already missed it. If you change the logic so it
runs the report as soon as the database is open and identifes any records
dated today, that's going to run repeatedly if you run the program several
times throughout the day. Worse if you don't open the database one day
(weekend, public holiday, illness), there are records that slip past without
any reminder.

The core idea might be to create a form (or report) that uses a query where
the DateOfPayment = Date(). Cancel its Open event if there are no records.
Create a function to OpenReport, with error handling to handle (and ignore)
error 2501 (then open was cancelled.) Call this function in your AutoExec
macro, or the Open event of your startup form.

(That's not dealing with the missed reminders, nor multiple reminders each
time you start on the same day.)
 
Thanx Allen,

Sure was an XClent suggestion and guidance. However, any idea where can I
find a sample of such a macro based file. Sure would appreciate your help in
providing such a sample.

Thanx again!
--

Best Regards,
FARAZ A. QURESHI


Allen Browne said:
There's a bit more to it than that.

If the database is not open at 9 am, it's not going to display anything. If
you open it at 9:05, you've already missed it. If you change the logic so it
runs the report as soon as the database is open and identifes any records
dated today, that's going to run repeatedly if you run the program several
times throughout the day. Worse if you don't open the database one day
(weekend, public holiday, illness), there are records that slip past without
any reminder.

The core idea might be to create a form (or report) that uses a query where
the DateOfPayment = Date(). Cancel its Open event if there are no records.
Create a function to OpenReport, with error handling to handle (and ignore)
error 2501 (then open was cancelled.) Call this function in your AutoExec
macro, or the Open event of your startup form.

(That's not dealing with the missed reminders, nor multiple reminders each
time you start on the same day.)
Click to expand...
 
I don't have an example.

Easy enough though. OpenForm (or OpenReport) is easy.
If error handling is new, this might help:
http://allenbrowne.com/ser-23a.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

FARAZ QURESHI said:
Thanx Allen,

Sure was an XClent suggestion and guidance. However, any idea where can I
find a sample of such a macro based file. Sure would appreciate your help
in
providing such a sample.

Thanx again!
Click to expand...
 
Back
Top