Creating Reoccuring Event Records

  • Thread starter Thread starter Kirk
  • Start date Start date
K

Kirk

I'm builiding a crew scheduling database. I need to be able to build a
reoccuring event like the reoccuring appointment function of Outlook. How can
I do it.

I enter one record - with an event name, crew name and date fields. The I
would like add (append?) additional records with the same event name and crew
name but new date field data, each 7 days after the last. I would like to be
able to select the number of addtional records or add until a certain date.

Any thoughts guys?

Kirk
 
I'm builiding a crew scheduling database. I need to be able to build a
reoccuring event like the reoccuring appointment function of Outlook. Howcan
I do it.

I enter one record - with an event name, crew name and date fields. The I
would like add (append?) additional records with the same event name and crew
name but new date field data, each 7 days after the last. I would like tobe
able to select the number of addtional records or add until a certain date.

Any thoughts guys?

Kirk
Click to expand...

easiest way is to create a deliberate partial cartesian product and
then append it to the destination table.
Dimensions:
1. Staff/Crew (choose from multi-select listbox)
2. Days ... use a calendar or a multi-select listbox again, populated
with a series of dates

Create cartesian product by adding StaffID or CrewID and Days, (No
Joins)
Use code at www.mvps.org for filtering query results with a mult-
select listbox
then append the results to your schedule table.
 
Back
Top