Repeating Visits

[chrisd49]

Hi All
I have a form which allows for a subcontractor to be allocated new tasks. Most of these tasks are repeating, ie weekly, monthly, quarterly, half yearly and annual. Try as I might I can't get my head round how to do this. On the form I have a drop down list and I would like to be able to pick from the list and automatically create all the tasks with the date on which it is scheduled.
I also have the start and end dates for the contract.
Any pointers, guidance etc would be much appreciated.

ChrisD

 

[GaryPanic]

I would have thought something along the lines of diary system with multiply options
if A selected then 1 date only no further action
if b selected then some date captuer field +7 days
if c selected then some date capture field + 14 days et

the date caputuer field would need an update qry on it so if datecaputerfield is less than today add on 7 days or 14 days

this would probably work on a qry -I am thinking out loud how you run the qry could be on a weekly push of a button - or some sort of automation daily

this route would overwrite the datacapture field - if you need this to show (ie a log) then a better route would be
if option b select then a dairy entry entered into a diary table 52 times (once every week for 1 year from that point )

I prefer the last this would make a lot of diary enties but gives a log and you can clear it down at a year end and either delete or archive it doing the last route you could then have a notes/action field
user types in whats happened etc - kinda like a audit trail and can print this off at year end clip to case/file - should keep the old bureacrats happy


may not be what you asked for - but might help

 

[chrisd49]

Hi Gary
Thanks for the input but I think I may not be explaining this to well. I have a form for task entry. On this form is a drop down list which enables me to pick if the task is a recurring one at he intervals specified. I want to generate a list of dates for the task, including the entered description of the task. I have an end date for the contract that the task is being entered for. I already have a mechanism that works for single date tasks for sending them to a history form when the task is marked as complete.
I hope this outlines my problem a bit clearer and any further advice would be welcome.
ChrisD