Rin Macro on a given weekday

[filo77]

Hi,

I have created a macro that sends a database report to an email.

Is there any way to "tell" Access to automatically run this macro, say, every Monday?

filo

 

[sfreeman@co.mer]

depends...

Is the database always running? If so, you would need to create code to run, probably in the timer event at least once a day to see if it is Monday, then run code to fire the macro (macros are bad - change that to vb :-B).

If the db is not always on, the create a Windows Scheduled task to fire up the database every Monday, and then set an autoexec macro to run the codd in question.

HTH

 

[filo77]

Thanks for your reply.

The db is not always on, so the second suggested solutions is the one that fits my needs best.

Now, how do I do all that????

filo77