Hi Everyone,
I'm trying to create a access form for attendance keeping purpose. Lets say it's 11 July 2018 4pm and the class name is "junior". How can I add multiple students to this class at a go instead of keying in one by one.
Thanks
Hi Everyone,
I'm trying to create a access form for attendance keeping purpose. Lets say it's 11 July 2018 4pm and the class name is "junior". How can I add multiple students to this class at a go instead of keying in one by one.
Thanks
make a master form for the Class table:
[classID], [Meet], [ClassLevel]
123, 11 July 2018 4pm, Junior
and a subform (bound to a sub table) for the Roster table:
[classID],[StudentID]
a student table holds the IDs
[StudentID], [FirstN], [LastN], etc
If all the students are in the tStudent table, then you can use a listbox on the subform (mentioned above)
to just dbl-click a student from the list ,which runs an append query, which adds them to the tClassRoster table