By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 853 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

condition

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
DatePart("d",date()) = 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" <ba********@ntlworld.com> wrote in message
news:YE*******************@newsfep1-win.server.ntli.net...
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.