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

[_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

 

[Steve Schapel]

Bigred,

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

- Steve Schapel, Microsoft Access MVP

 

[_Bigred]

when i try to run i get undefined function 'date' in expression


Later,
_Bigred

 

[_Bigred]

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

 

[Steve Schapel]

Bigred,

Are you sure the error relates to the macro condition expression? It
could also refer to something else related to the action the macro is
performing. (Or in your case, not performing!)

All I can suggest at the moment is to check the References. For
information on this aspect, see...
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

- Steve Schapel, Microsoft Access MVP

 

[_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

 

[Steve Schapel]

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

 

[_Bigred]

I will double check this, and let you know.

Thanks,
_Bigred