Automate Attendance

[Palomino33]

Daily Task: Take attendance daily.
Goal: automate more.
Currently done every day:


I enter the current date, the student ID# (primary key from student table) which pulls basic demographic, and then I enter numbers 3, 2, or 1 for how many classes they attended that day. Done for each student daily.

I have the following in my db:
A Table of All students. An attendance table for historical data. Most students attend 3 classes a day; however some may attend 2 and on a rare occasion, maybe 1 class per day. A query of active students (say I've got 10 active students) that is related to the attendance table.

Hope to get:
A full class roster form....of the 10 students, with the date auto defaulted to "today"....and a default number of 3 in each attendance field. If the student does less than 3, I will manually change those numbers.(rare) Then I want the attendance information to go to the attendance table.
Thank you in advance.

[June7]

Two ways to do this.

1. Use code to add a record in attendance table for each student. This would be an INSERT SELECT WHERE sql statement. Open form filtered to that set of new records. Edit the records as needed, delete any that did not attend.

2. An unbound form with 10 rows of unbound textboxes with default values and check box. Code would save rows that are checked yes. Not really right for your situation if the active students change frequently. Would have to modify form to change the default name in the textboxes. And what if you add an 11th student?

Here are some threads that discuss this topic:
https://www.accessforums.net/forms/p...orm-17442.html
https://www.accessforums.net/queries...ion-19339.html
https://www.accessforums.net/forms/a...orm-16468.html

[Palomino33]

#1 sounds like it would work. Can you tell me more about how to do this?

#2...doesn't sound applicable...students change about once a week.

[June7]

I think the threads have a lot of info to get you started. Does require VBA programming knowledge. Make attempt and when encounter issue post specific question. I expect you will want a button on some form, maybe a 'menu', that is labeled 'Add Today's Attendance'. Code in that button's Click event would create records and open data form.