How do I set up preventive maintenance schedules in Access 2003

[Harvey Walker]

Using Service Call Database how do you set up to schedule work orders for
next due date, generate and print work orders when work is due based on
equipment? I have set up the work order database for call in work orders but
need to schedule recurring maintenance work orders.

 

[KARL DEWEY]

Create a PM table that list all the PM services you will perform. In this
table use the lowest common denominator of your intervals. Most folks do not
call a daily a PM but have weekly as the lowest interval. If weekly is your
lowest then compute all services in multiples of weeks - a 2-month would be 9
weeks, 6 months would be 26 weeks.

Decide when the next PM will be scheduled based on last schedule or last
completed.

Build a reference table of all equipment, services (PMs), Last PM date, and
flag for last schedule or last completed.

Run update query each time a PM work order is closed - flagged closed.

Generate PM work orders each week for the next however many weeks you plan
in advance. Use an append query to generate the PM work orders.