Run macro to run archive queries once a week without user confirmation

[PoniKika]

Hi there, I am amending a database which has several tables and queries.

There is currently a form based user input method, and from the main menu form there is an archives menu with 6 buttons on it running 6 different macros.

The macros (for example 'mcrDeliveryArchive' runss an append query which places all records over six months old into an archive table, and then runs a delete query which deletes there records from the original table).

I was wondering if a condition could be set on the macro to enable the macro to run once a week, say on a saturday, without the users having to physically press a button to run the macro. Any help would be appreciated, thanks.

 

[HitechUser]

PoniKika,

These is no easy to schedule something in Access. So...

I would "clone" the macros and then turn off confirmation messages. Then I would use this. HAL

Good Luck...