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?

--
Best Regards,
FARAZ A. QURESHI

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.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"FARAZ QURESHI" <FARAZQURESHI@discussions.microsoft.com> wrote in message
news:C352D087-2459-4486-9E9D-8F0FC97354CA@microsoft.com...
> 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?
>
> --
> Best Regards,
> FARAZ A. QURESHI

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" wrote:

> 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.)
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "FARAZ QURESHI" <FARAZQURESHI@discussions.microsoft.com> wrote in message
> news:C352D087-2459-4486-9E9D-8F0FC97354CA@microsoft.com...
> > 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?
> >
> > --
> > Best Regards,
> > FARAZ A. QURESHI
>
>

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
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"FARAZ QURESHI" <FARAZQURESHI@discussions.microsoft.com> wrote in message
news:CEC730EF-4396-43C4-821A-C09F1F54C035@microsoft.com...
> 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" wrote:
>
>> 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.)
>>
>> --
>> Allen Browne - Microsoft MVP. Perth, Western Australia
>> Tips for Access users - http://allenbrowne.com/tips.html
>> Reply to group, rather than allenbrowne at mvps dot org.
>>
>> "FARAZ QURESHI" <FARAZQURESHI@discussions.microsoft.com> wrote in message
>> news:C352D087-2459-4486-9E9D-8F0FC97354CA@microsoft.com...
>> > 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?
>> >
>> > --
>> > Best Regards,
>> > FARAZ A. QURESHI
>>
>>

Thanx!

An XClent site u've got! Great!
--

Best Regards,
FARAZ A. QURESHI


"Allen Browne" wrote:

> 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
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "FARAZ QURESHI" <FARAZQURESHI@discussions.microsoft.com> wrote in message
> news:CEC730EF-4396-43C4-821A-C09F1F54C035@microsoft.com...
> > 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" wrote:
> >
> >> 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.)
> >>
> >> --
> >> Allen Browne - Microsoft MVP. Perth, Western Australia
> >> Tips for Access users - http://allenbrowne.com/tips.html
> >> Reply to group, rather than allenbrowne at mvps dot org.
> >>
> >> "FARAZ QURESHI" <FARAZQURESHI@discussions.microsoft.com> wrote in message
> >> news:C352D087-2459-4486-9E9D-8F0FC97354CA@microsoft.com...
> >> > 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?
> >> >
> >> > --
> >> > Best Regards,
> >> > FARAZ A. QURESHI
> >>
> >>
>
>