timer/date event set to print on 1st mon of month

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_Bigred

(Access 2000)


I am wondering it someone can tell me if it is possible & how to:

setup a macro to run at startup that would check the date and "IF" it is the
first monday of the month it would print several monthly reports (for a
meeting that happens on the first monday of every month)??

any ideas would be appreciated,

_Bigred
 
Bigred,

Put this in the Condition column of the macro...
Day(Date())<8 And Weekday(Date())=2

- Steve Schapel, Microsoft Access MVP
 
I put the following in the condition column of the macro, and got an error:

Day(Date())<8 And Weekday(Date())=2

It returns the following error when I try to run it:

The expression you entered has a function name that Afscme Local 3409
Grievance Database can't find.

Any ideas?

TIA,
_Bigred
 
Day(Date())<8 And Weekday(Date())=2

when I go into the macro click "step" it errors and give me the following:

Undefined function 'Date' in expression
 
Bigred,

As mentioned previously, the only thing I know of which can cause this
is a missing or broken Reference. Did you check the Doug Steele
article I referred you to?

- Steve Schapel, Microsoft Access MVP
 
Back
Top