add-memberalign-toparrow-leftarrow-rightbellblockcalendarcamerachatchevron-leftchevron-rightchevron-small-downchevron-upcircle-with-crosscomposecrossfacebookflagfolderglobegoogleimagesinstagramkeylocation-pinmedalmoremuplabelShape 3 + Rectangle 1pagepersonpluspollsImported LayersImported LayersImported LayersshieldstartwitterwinbackClosewinbackCompletewinbackDiscountyahoo

Re: [PhillyDB] requesting help on MS Access Database

From: Michael R.
Sent on: Tuesday, November 15, 2011 10:08 PM
Hi Maneesha -

I don't know if you got any direct replies, and I'm unable to help with Access myself, but you might try this Access forum

Good luck!

--- On Tue, 11/15/11, Maneesha <[address removed]> wrote:

From: Maneesha <[address removed]>
Subject: [PhillyDB] requesting help on MS Access Database
To: [address removed]
Date: Tuesday, November 15, 2011, 2:32 PM

Hey everyone:

I am requesting some help on an Access database I'm building for the Philadelphia Mural Arts Program to track participation in one of our special projects.  I'm hoping someone can help!

I have three tables with fields as follows:

Table Participants:  Participants enroll in our program and we collect name, address, phone, etc and whether they are enrolled at site  X, Y, or Z and for program Year 1, 2, or 3.  Participants can not enroll for more than one year or more than one site.

Table DailyWorkshops:  Daily workshops are set up to show the workshop date, whether it was an A or B session (two sessions per week), who staffed that day's event, what artists attended, and what activities went on.

Table ParticipantAttendance:  Then I want to be able to check off what participants showed up that day.  I have a form DailyWorkshops and want to have a subform/subtable that I can check off whether each participant attended All, None, or Part of that day's session.  I'm having trouble creating that subform.   I think this information should ultimately be STORED in the ParticipantAttendance table but I'm trying to figure out how to have an input table to check off the participants each day.

Any help would be so much appreciated.... I can share the database as I've built it so far if anyone wants to look at it and send it back to me or talk on the phone .... thank you so much!!

**Table: Participants** 

**Table: DailyWorkshops**   

**Table:  ParticipantAttendance**   
ParticipantID   Participants.ParticipantID
FirstName   Participants.FirstName
LastName    Participants.LastName
WkshpID DailyWorkshops.WkshpID
Level   *(here I have a lookup to fill in HALF/PARTIAL/FULL, not just yes/no)*

Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Maneesha ([address removed]) from PhillyDB.
To learn more about Maneesha, visit his/her member profile
To unsubscribe or to update your mailing list settings, click here

Meetup, PO Box 4668 #37895 New York, New York[masked] | [address removed]

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy