Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / November 2006

Tip: Looking for answers? Try searching our database.

attendance

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bill H. - 03 Nov 2006 19:04 GMT
I'm trying to develope an application that can track attendance at various
classes of varying times and dates.  So, looking for some ideas.

I've got the tables for the classes and their dates (start/stop, and dates
for each meeting, which can change, be added to or removed from the original
schedule).  Also have registration tables showing which student is
registered for what class.

I'd like to be able to call up a course from the course list, and see all
those registered, and be able to mark attendance, like in a spreadsheet,
where the names are on the left, and each column on the right represents
each meeting date.  If they come, they check a checkmark, if not, no
checkmark.

And of course a way to handle those that register after class has started
(so they start showing up in the attendance form).

Thanks.

Signature

Bill

Duane Hookom - 03 Nov 2006 21:03 GMT
This all depends on your table structure(s). Assuming you have a main form
with the class information and a subform with separate records for each date
of the class. You could run an append query that would add records to an
attendance table of Class, Dates, and StudentIDs. You can then delete the
students who didn't attend the class.

Signature

Duane Hookom
MS Access MVP

> I'm trying to develope an application that can track attendance at various
> classes of varying times and dates.  So, looking for some ideas.
[quoted text clipped - 15 lines]
>
> Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.