My First Post - help please
The project involves a main form with large Check-In and Check-Out command buttons. When a student clicks the Check-In button a parameter query asks the student to scan his/her ID card. The Student database is searched and the student's information is displayed along with the check-in date and time. A combo box allows the student to select a course to study. I need to learn how to store this information in a student activity log and return to the main form again. After the study period the student would click the large Check-Out button, scan their ID card and a select query would search the student activity log for the students ID and today's date for a match then update the student activity log with the current date and time before returning to the main form again.
I use three tables, three forms and two select queries.
1. tblStudents (a list of student information)
autonum
ID number (six digits)
Name
Grade.
2. tblStudentActivity (a log for check-in and check-out dates/times)
autonum
StudentID
Course
DateTimeIn
DateTimeOut
Comments
3. tblCourseTitles (used with unbound combo box on frmCheckIn)
autonum
Course
4. frmMain containing
a label as a title heading
a large command button for Check-In (opens the Check-in form)
a large command button for Check-Out (opens the Check-Out form)
a medium side command button for Closing the program.
5. frmCheckIn
Prompts the student to scan their ID card
Displays the students information and check-in date and time
Allows student to select a course title from a combo box
I probably need to add a "save record button" also but am not sure how to store the displayed info in the Student Activity table'
6. frmCheckOut
Prompts the student to scan their ID card
Checks the Student Activity table and displays today's check-in info plus the check-out date and time. I haven't gotten this far yet because I could not figure out how to store the Check-in information.
Any help would be appreciated. I only know bits and pieces of access but will signup for the next ed2go class.