Re: [PhillyDB] requesting help on MS Access Database

From: Angel P.
Sent on: Wednesday, November 16, 2011 9:59 AM
Maneesha, you are repeating information between Participants and ParticpantAttendance, not a good thing to do. I don't know how Access forms do cross-table referencing, but it should be possible.

As for HALF/PARTIAL/FULL, Access should allow an enumeration of allowable values in their form creators. This would essentially translate to  some sort of drop-down-selection form element. 

-angel

On Wednesday, November 16, 2011 at 9:46 AM, Maneesha wrote:

Thanks!

The forum seems to be down right now.  Hopefully that's just a temporary thing.  I'm still trying to figure this out...

-maneesha




On Tue, Nov 15, 2011 at 10:09 PM, Michael Reichner <[address removed]> wrote:
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

http://www.access-programmers.co.uk/forums/

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**  
ParticipantID    
FirstName    
LastName     
Address
Phone
SiteNameLookup   
YearLookup

**Table: DailyWorkshops**    
WkshpID  
WkshpDate    
AorB     
SiteStaff    
Artists  
Activities

**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]




--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Michael Reichner ([address removed]) from PhillyDB.
To learn more about Michael Reichner, 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]





--
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