MSGBOX Reminders

[James]

Hello I would like an MSGBOX to pop up on the switchboard
whn a database is opened. I would like it to have a MSGBOX
to say that the following ID is up for review on (DATE
HERE).

I would like the follwoing on each record which comes
up... So for example if the review date is in a weeks time
then it comes up with:

The follwoing Case (Case Number here) is up for renewal in
one week (Date Here).

The same for the day before and the day its up for renewal.

Also could I add the time aswell for like a meeting date
for the review?

Many Thanks

James

 

[Howard Brody]

Since it looks like you could have multiple IDs appear on the same date, I would actually do it as a report instead of MsgBoxes. This way, your users will have a hardcopy of the information and they won't have to copy it down from the pop-up. Just put the report in your AutoExec macro or build one if you don't have it already. (When a database opens, it will automatically run a macro named 'AutoExec')

Hope this helps

Howard Brod


----- James wrote: ----

Hello I would like an MSGBOX to pop up on the switchboard
whn a database is opened. I would like it to have a MSGBOX
to say that the following ID is up for review on (DATE
HERE).

I would like the follwoing on each record which comes
up... So for example if the review date is in a weeks time
then it comes up with

The follwoing Case (Case Number here) is up for renewal in
one week (Date Here)

The same for the day before and the day its up for renewal

Also could I add the time aswell for like a meeting date
for the review

Many Thank

Jame

 

[James]

So how do I get a report to run off that sort of
information?

Many Thanks

James

-----Original Message-----
Since it looks like you could have multiple IDs appear on

the same date, I would actually do it as a report instead
of MsgBoxes. This way, your users will have a hardcopy
of the information and they won't have to copy it down
from the pop-up. Just put the report in your AutoExec
macro or build one if you don't have it already. (When a
database opens, it will automatically run a macro
named 'AutoExec').