condition

[BARRY NEWINS]

High All
I have set up an auto execute macro to run a report when the database is
opened.
Ideally I would prefer to have the report sent out on the first opening of
the database each month.
I presume that this would be set in the condition section of the macro but
that's where my brain dries out.
anyone help with the expression to enable me to do this?
Cheers
BJ

[Mike MacSween]

Re: condition

DatePart("d",da te()) = 1

What happens if the 1st is on a weekend and you don't work then?

Is this a printed thing? Personally I've always steered away from
autoprinting depending on date. There are too many things to go wrong.
Printer not turned on, out of paper, jams etc. etc.

Mike

"BARRY NEWINS" <bazzer1956@ntl world.com> wrote in message
news:YE%bb.1006 $lT6.748883@new sfep1-win.server.ntli .net...[color=blue]
> High All
> I have set up an auto execute macro to run a report when the database is
> opened.
> Ideally I would prefer to have the report sent out on the first opening of
> the database each month.
> I presume that this would be set in the condition section of the macro but
> that's where my brain dries out.
> anyone help with the expression to enable me to do this?
> Cheers
> BJ
>
>[/color]