Regular Reminder type thing

[bgcogen]

Hi.

Any ideas anyone:

Basically the user inputs into a form when they did a particular site maintanence e.g. "Did monthly left engine check on 12/6/02". The user inputs this weekly/monthly/bi-monthly etc data into a form when they do it. All that's grand.

I want the database to create a report for a particular period saying on request something like "On 12/7/02 check the engine, On 17/7/02 check the boiler etc".

Can this be done????

Thanks,
D


:-D

 

[ColinEssex]

Hi

Would this be something like a regular check every so many months?

Engine 2 months
Boiler 3 months

etc etc

If so, when they enter a date that they's just done it, have another date come up automatically in a box (nextDate)

You'd need some code OnExit of the first date

If Me.ItemName = "Boiler" then
Me.NextDate = Me.FirstDate + 60
elseif Me.ItemName = "Engine" then
Me.NextDate = Me.FirstDate + 30
end if

Thats a bit rough - you could use a case statement if you prefer.

You can then make a query to see things that need to be done in the next x days based on the NextDate field.

Hope this starts you off

Col

 

[FloBob]

I have a ticket system that lets the users set up scedules for there tickets IE one week one month.. or they can just enter in a date that the ticket needs to be recreated.. It uses all the data off the original ticket but can be changed. Is this what your after if so I can walk you thru most of the code. Oh and its reacurring aswell.