| Patrick Salsich 2006-01-12, 9:24 am |
| A popup message will most easily be triggered by an event on a form. The
opening screen of your app can do it, or use the "on current" event of any
form that is used to view the clients. You could write some code to do a
dlookup on a table or query that has as one of it's output columns the
number of days left for any due date. That can be done by simple
subtraction such as: Now() - [whateverdate]
Easiest of all would be a simple report that opens in preview mode whenever
you start the app or whenever you ask for it.
personally I think popups are overrated. It's kind of "bells and whistles"
stuff. Just run the report regularly.....
"jiji" <jisaad@videotron.ca> wrote in message
news:g28xf.68286$2O3.1279279@wagner.videotron.net...
> I am looking for a way to have a pop up message saying that my clients are
> due to pay their bill with 3 days. pls help, I am not too much familiar
with
> macro or any other programmation but i can catch fast if you explain to me
> in details. thank you
>
> jiji
>
>
|