Trouble with Recurring Records

[TinaM]

I do not have extensive experience with code but understand how it works -
I'm building a mdb to track tasks and need to have a record recur or
duplicate multiple times based on criteria completed in a subform of my main
form but then have start and end dates modify based on a number entered by
the user for a frequency picked from a combo box. Anyone have experience
with something like this?

 

[Jeanette Cunningham]

Hi Tina,
there is a sample database that builds tasks for the future at this website

http://allenbrowne.com/AppRecur.html

It will give you some ideas and get you started.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Mike Painter]

I do not have extensive experience with code but understand how it
works - I'm building a mdb to track tasks and need to have a record
recur or duplicate multiple times based on criteria completed in a
subform of my main form but then have start and end dates modify
based on a number entered by the user for a frequency picked from a
combo box. Anyone have experience with something like this?

In general duplicate records will present problems in a relational database.
If the only thing that changes is a start and end times then a related
table that just contained these dates and the data that caued the change
would usually be a better choice.

 

[TinaM]

Thank you for your help. I ended up creating recurrence tables as suggested
in this sample and by Mr. Painter. Still working on it so not sure yet how
well it works.

 

[TinaM]

Thank you for your help. I did end up creating a Recurring Events table(s).
Not yet complete so not sure how well it will work out.