I've searched comp.databases.ms-access for a solution and found help
but still haven't got my problem solved. I want to record weekly
attendance and print an attendance "check off" sheet where attendees
simply check on their name row and class date column to record their
attendance. The marked attendance sheet is later used to update the
database and print an updated attendance sheet for the following
week's class. I'm working with about 200 names and have set up the
following tables:
tblMembers with IDMem (Autonum); LastName; FirstName
tblClass with IDClass (Autonum); DateClass
tblClassAttend with IDMem (LongInt); IDClass (LongInt); Attend (Y/N)
I've created a SELECT query (qryClassAttendance) with all three tables
related tblMem (one to many) tblClassAttend (many to one) tblClass.
I'd like to use just a form (frmClassAttendEntry)(continuous) to both
record attendance and print the check-off sheet. I want the form to
list the LastName, FirstName of EVERY name in the database not just
those who have attended a class and then have columns headed with the
Class Dates, past, current, and future with check boxes to show past
attendance (to complete the picture -- pencil marks for the current
class and blank check boxes for the future classes). So if you look
across you see a person's attendance record and looking down shows who
did or did not attend a given class. In Form View, I want to be able
to put checks in the check boxes to capture the attendance for a given
class and then, based on the current date, have the column heading
date controls increment so that the printed form will always show
about three columns of past classes, the current class, and two blank
attendance columns for future classes.
frmClassAttendEntry's record source is qryClassAttendance. I'm not
able to see how to list each name only once on the form. The query
will only produce names of those who have attended a class at some
point and will repeat names unless I specify a specific IDClass as a
parameter. I have no idea how to make the check boxes in a column
relate only to a specific class.
How can I get the form to list all names in the database?
How do I set up columns of check boxes and uniquely relate the check
box column to one class date?
How do I create a moving window of class date columns so each week the
printed form will have three prior, one current, two future class date
columns?
Thanks for any and all help!!!!!
Bill