How to run a macro once a year/month

**jvbeats** · 02-02-2013, 01:35 PM

Hi I working with access and would likea macro to to run a backup query once a month.
Also I would like to execute an update query (with new year fields), once per year.

both should run to check if it should execute everytime on open.

Thoughts?

**alansidman** · 02-02-2013, 01:49 PM

Look at this link. In the DateDif line, you will need to change the criteria to months and years.

http://www.tek-tips.com/viewthread.cfm?qid=670401

Here is a link on how to use DateDif

http://www.techonthenet.com/access/f...e/datediff.php

**jvbeats** · 02-02-2013, 02:21 PM

Looks great, I'll screw around with this. Appreciate it...

**jvbeats** · 02-02-2013, 03:11 PM

Does the timer run for a year every time the databse is open? will the timer execute the macro if the database is not open during that exact time?

**alansidman** · 02-03-2013, 10:12 AM

http://www.bluemoosetech.com/microso...0Timer%20Event

I think that you will have to add a scheduled Windows task to have it open and run Access for the events to take place. I personally have never done this. I think that a google search may be the most productive way to find a good answer for this.