Scheduling PMs on Tue and Thursday instead of every five days

Bob,
Here is a link to a .mdb that has an example table that will hopefully be
self-explanatory. Code for creating a calendar table is also included.
http://cid-4c94bae9d21e677e.skydrive...ringEvents.mdb

"Bob Waggoner" wrote:

Bruce,
I would welcome your help. Thank you. Please send code/examples.
Bob

"Bruce Meneghin" wrote:

Can I suggest a more generalized method of storing your "maintenance event"
rules.
You can have a table that stores the maintenance information:
fieldName example
ID 1
Frequency weekly
monthName null
dayName Tuesday
number null
eventName tuesday lube
beginDate 1/1/1900
endDate 1/1/2999
skip null

This table can store any type of recurring event like check tire pressure on
third Tues. of each month. I can send you a table with examples that shows
all variations.

So, you enter your PM events in this table; you would have a record for the
Tues. maint. and one for the Thurs. maint.

Then you can have an association table that assigns one or more PM events to
each piece of equipment.

Then you have some code that generates a calendar of PM events; this can be
done by date or by equipment. I can send you the code.


"Bob Waggoner" wrote:

My database is set up to remind maintenance of PMS due based on the last done
date. Now maintenance is asking for specific equipment to be PM'd on Tuesday
and Thursday (greased). I know Outlook allows you to schedule activities on a
recurring basis and you can pick the day(s) of the week that they recur. Can
anyone help me do that? I have no idea where to begin with that code/form/etc.
Thanks so much for your help.
Bob