Maintenance Scheduler - HELP

[mea99sdp]

Hi

I'm trying to make a Maintenance scheduler, the task are repeated every week, monthy, quarterly, bi-monthly, or yearly. how do i get the database to repeat tasks after their due date has expired?

for example table

TASK-overhaul machine
FREQUENCY-monthly
START DATE-1st/jul/07
DUE-(start date+one month)

so the machine is due for overhaul on the 1st/aug/07, then again 1st/sept/07,etc

Can access change the start date after that date has pass? or is there another way?

 

[pbaldy]

I guess it depends on what you want. I've got an app with scheduled items, but we want to keep a history, so I create a new item with each date. So in your example, I'd have a record for the task on July 1 and another record for the task on August 1.

You could probably come up with a way to change the date on any that passed, but what if they hadn't been done yet? They'd drop off your list of tasks needing to be done. You could perhaps add a "done" field, and only update those.

You need to think out the process in terms of your situation and determine which is appropriate for you.

 

[mea99sdp]

I dont need it to keep a record, as i plan to print off what tasked are need to be done today or this week, it is more as a reminder of jobs to be done. i like the idea of a done field, but i dont want to be updating it every day, just autorun, print list off, then close

 

[pbaldy]

Well, it won't be hard to return a list of all tasks whose due date has passed. It's not hard to change that to an update query that changes the date either. The tricky part will be determining what to change it to, because of the weekly/monthly/etc thing. The simplest solution would be if the record contained the values required by the DateAdd function. If you look that up in VBA Help you'll see what I mean. You're looking for the interval and number arguments.