asked on

Attendance records in access

Access 2003
very new to Access and am building a database for my club
I have a table with members details, I want to record their attendance, but would like to do it all on 1 page (Form) from my switchboard.
How do I display all members names with a check box (ticked for yes) then save it and update the attendance table with their ID, meeting date, and yes or no?

Chris B

It can all display on one form, but you want two tables, one the list of all members, the other recording attendances on particular dates, then a report showing who came on which date. If you email me your db (address on my profile - click my name above), I will set up the basics and you can go from there.

Chris B

Patrick Matthews

Hi Chris,

> If you email me your db

Using email is not allowed. If the Asker wants to provide a sample file, s/he should upload it to an accessible web site
and post the link to it here, so that all interested Experts can work on it. If the Asker does not have such web space
readily available, s/he can upload to www.ee-stuff.com.

Regards,

Patrick

ASKER CERTIFIED SOLUTION

Patrick Matthews

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Chris B

<<Using email is not allowed.>> I see your point, but I have done it many times ... Can't see how the offer of free assistance can be an issue. The asker can respond or not as they see fit, and any other respondent to the question may influence the outcome completely differently to any suggestion offered by me. Happy to post my suggested structure to ee-stuff for others to critique as they wish.

Chris B

Arthur_Wood

burrcm>> the point is not that the offer of free assistance is an issue, but rather that your assistance should be openly available to all members of EE who might want to learn. By emailing you the db, and you then emailing it back, that assistance is restricted to you and Netwitz, and no one else can learn or offer alternatives.

AW

Chris B

<<should be openly available>>. Point taken. Yes you are of course correct.

Thanks

Chris B

SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial