If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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 |
|
Thread Tools | |
Display Modes | |
|
|