Hiya TIA,
You need to change your macro to be a conditional macro. ie Your macro will
only run when the condition you set is OK.
In your macro, click the View drop-down and choose Conditions. This is where
you put the criteria for your macro to run. Try something like
Weekday(Date())=2 And Day(Date())<8.
This will only run when the WeekDay is a 2 (Monday), and also only when the
month day (From 1 to 31) out of the current date is less than 7. The first
Monday must of course fall into this range.
Stick in all your actions, and away you go.
BUT you will still need to attach this macro to something to run. It won't
just 'kick in' automatically. You could either attach it to a form load
event, or maybe better, put it as a command in an AutoExec macro.
Hope this helps,
Piers
| Does anyone know how to run a macro, when it is the first monday of each
| month???
|
| TIA,
| _Bigred
| ---------------------------------
| (e-mail address removed) (change con to com)
| God Bless Rock N' Roll
|
|
