Creating Reoccuring Event Records

[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

 

[Piet Linden]

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

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.

 

[Duane Hookom]

There is a "recurring" sample database for download at
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=18.

 

[Allen Browne]

And here's another one:
Recurring events - how to handle recurring events that may never end
at:
http://allenbrowne.com/AppRecur.html