Greetings everyone...
I developed an accounts payable system under Access 2003. I was wondering
whether there is a code or macro that can work in the background and shows a
form or a message with a reminder when a bill(s) is (are) due (something like
the reminder in outlook.
I appreciate any help
Cheers

You could create a query to perform the check based on your criteria and then
use a form to display the results. Then using an autoexec macro you could
run the query when the db gets launched and if there are results open the
form to display the results.

Daniel




"Omar" wrote:

> Greetings everyone...
> I developed an accounts payable system under Access 2003. I was wondering
> whether there is a code or macro that can work in the background and shows a
> form or a message with a reminder when a bill(s) is (are) due (something like
> the reminder in outlook.
> I appreciate any help
> Cheers

Thanks Daniel,
this is a nice solution. appreciate your help

"Daniel" wrote:

> You could create a query to perform the check based on your criteria and then
> use a form to display the results. Then using an autoexec macro you could
> run the query when the db gets launched and if there are results open the
> form to display the results.
>
> Daniel
>
>
>
>
> "Omar" wrote:
>
> > Greetings everyone...
> > I developed an accounts payable system under Access 2003. I was wondering
> > whether there is a code or macro that can work in the background and shows a
> > form or a message with a reminder when a bill(s) is (are) due (something like
> > the reminder in outlook.
> > I appreciate any help
> > Cheers