Weekly job.

[sdawson]

I'm sure this must have been the subject of a thread before, but after an hour seaching my head aches.

I'm running (Access 2000 on XP Prof) a sort of planning board. The week commencing dates change automatically, as per previous postings on here.
I have a job run from a command button to then change a field representing the week the job is to be run in ie week 2 jobs to week 1, week 3 to week 2 and so on. So far so good.

I would like this job kicked off automatically once the first time the db in opened in the new week.
Any advice or pointers to appropriate thread welcome.

Ta

 

[ScottGem]

The question is how you define the new week. I would create a parameters table that would be updated with the date when the update was last run. A parameters table is a one record table that contains values used in processing.

Then, run your code either in an Autoexec macro or your startup form to check to see whether the last run is before the current week start.

 

[sdawson]

I understand what you are saying and this was my thinking.
Probably easiest way may be to use Windows task scheduler.
Trying to find a compilcated answer to a simple question!

Thanks

 

[ScottGem]

Windows Task Scheduler is fine for opening the app on a schedule. But you still need to have an autoexec macro or startup form to run the code when the app opens.

 

[sdawson]

Understood.

Thanks