Structure to support Calendar report

[Stephanie]

Hi. This is for now a table and form questions, but
ultimately I want to build a generic (5-week) month
calendar.

I have Contacts that Volunteer at facilities. Volunteers
visit various facilities at various intervals. Examples:
every Saturday, first Wednesday of the month, every other
Monday, Tuesdays and Thursdays every week. So I think I
need a subform that allows me to have a datasheet view of
Days, a field for frequency and a field for timing (which
week of the month). Sounds OK or am I missing something?

I think I may have some table issues so I'm trying to
figure out if what I have will support what I need.

Currently I have:
tblVolunteering
VolunteeringID
FrequencyID
DaysID

tblFrequency
FrequencyID
FrequencyText

tblDays
DaysID
DaysText

I want to be able to support multi-Days, but I don't
think this structure allows me to do so. I admit I get
FK backwards. But when I tried to change things up
tblVolunteering wasn't happy.

I'd appreciate suggestions to get me on the right track
to build my report. Thanks, Stephanie

 

[Duane Hookom]

You might want to review two samples:

Roger Carlson's site
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

The Recurring sample shows how to use a form to set up recurring scheduled
events.

Corp Tech
http://www.invisibleinc.com/divFiles.cfm?divDivID=4

The Calendar Reports sample has several sample reports based on a fairly
normalized table structure.

 

[Stephanie]

Thanks for the links.
Stephanie

-----Original Message-----
You might want to review two samples:

Roger Carlson's site
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hoo kom,Duane.

The Recurring sample shows how to use a form to set up recurring scheduled
events.

Corp Tech
http://www.invisibleinc.com/divFiles.cfm?divDivID=4

The Calendar Reports sample has several sample reports based on a fairly
normalized table structure.


--
Duane Hookom
MS Access MVP
--




.