Attendance Form Help

[plog]

For every class/week you would have to click that 'Add Enrollment' button to populate the Attendance table with the Enrollment for that week.

 

[chellebell1689]

I'm sorry I don't know if I'm being dumb or if the heat is getting to me...Does when you say "to populate for that week" does that mean it will automatically show up the names or that I will have to enter the names every week? If it does mean I have to add every week, is there any other way to do it so I don't have to re-enter every week?

 

[plog]

Nothing is automatic. Nor will you have to enter names every week.

You will have your form open to a Class and week as I mentioned before. It will be blank, you will click a 'Add Enrollment' button at the top, VBA will fire that creates a record in the Attendance table for every person enrolled in that class, each record will be dated with the date the form is open to, the sub-form of that form which is based on the Attendance table will refresh to show those new records at that time you can then mark who was Present/Absent.

You will not have to manually enter names every week, but you will have to manually set up Enrollment in a class once and you will have to manually click a button to add the appropriate records to the Attendance table for every class/week you want to take attendance for.

 

[chellebell1689]

That sounds great, my only problem is I no nothing of VBA. Can you point me in the direction of a tutorial that can help me set this up? Also, can I add people to the class as needed and take them off the roster?

I'm starting to think I'm too noob for this task lol.

 

[plog]

There's not a tutorial specifically geared for you. The topics you will need to learn are:

VBA RecordSets
VBA Loops
Executing SQL in VBA

 

[chellebell1689]

-_- I'm at the point I will pay someone to do this for me! So many headaches over something that seems so simple.

Ok. Thanks for all the help and explanation. I will research those topics.