Print a roll sheet for a class

[jaromluker]

I've searched the forums, but nobody who's printing roll sheets seems to be doing it the way I would like to do.



In essence, I've got two tables with a many-to-many relationship: Students and Classes.

I've created a form where a user can select a class from a Combo Box and select a month from another ComboBox. These boxes are named CurrentClass and CurrentMonth respectively. I have a report set to print all the Students in CurrentClass, but I'd like to be able to print what days of CurrentMonth the class is held (e.g., 2, 4, 6, 9, 11, 13, 16, 18, 20, 23, 25, 27, 30 for a M/W/F class in September 2013) in the page header with boxes to check attendance for each student for each day. I should mention there are Yes/No fields (Monday, Tuesday, Wednesday, Thursday, Friday) in the Classes table so that I am able to reference which days each class is held.

Is this a possibility? Does the programming even leave it worth the time?

Appreciate any help,
Tired and frustrated,
Jarom

[June7]

I am sure it is possible but the programming effort could be extremely challenging.

Could have a report that prints all days of month across the page with each student listed below. You might find this of interest https://www.accessforums.net/databas...ses-18459.html

More code might be able to blackout the daily boxes that don't apply for each student and here's where 'extremely challenging' kicks in.

[jaromluker]

Well, I think I might have to create a policy that requires the students to check in at the office before class and then have a form for entering attendance. The code would be easier, I think, assuming the kids actually do as they're told...

[June7]

Herding cats probably easier.

Aren't teachers supposed to take attendance?

A simple spreadsheet in Excel could produce the form for pen/paper attendance marking. But if you want to track attendance need a database. There is a student database template offered by MS for Access 2007 that is supposed to handle attendance. I don't think this 2003 version does attendance http://office.microsoft.com/en-us/te...in=HA001234159.

[detaylor1242]

How about this,

Create a table for a Class that contains the course number, description, and dates. If there are several of the same class being taught at the same time, then add and an extension (Classno +a)the the class number. In the student records link that class number to the student. Then create a query for the class roster and print it for each of the individual days. IF you want a full record for each student then you would need to create a new table for each student to record each day that the student attended.

[orange]

Here is a free data model that includes a Student Roster.
Hope it's helpful to you.
http://databaseanswers.org/data_mode...ters/index.htm

[jaromluker]

The teachers take attendance, but they don't have access to the computer, which is located in the office. This isn't for a school, though I can understand that assumption. Thanks for the link. It looks like there are some good stuff on there.

[jaromluker]

I have seen this, and I appreciate it, but it still doesn't accomplish my original goal. I've had software that has done what I'm looking to do, but the classes were all taught on the same one day per week, so it was a much simpler design concept. I guess outside of spending hours upon hours figuring out the right code, this is as good as it gets. Thanks for the input.