Trouble with Recurring Records

  • Thread starter Thread starter TinaM
  • Start date Start date
T

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?
 
TinaM said:
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?
Click to expand...

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.
 
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.
 
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.
 
Back
Top