Using Recordsets
Programmatically access your data using VBA code. Also multi-select listboxes.
Q: I need to track attendance for students in my class. Is
there a way to show a list of all of the students in my class, click on
the students that are absent, and then save that information to a table
so I can report on it later? I need to do this every day, so it needs to
be easy and fast.
A: The easiest thing to do
would be to create a multi-select listbox with all of your
students in it. Click on the students that are absent, and then use a
Recordset to programmatically add those students to an "attendance
history" table.
I know this might seem confusing, but it's real simple.
See this Free Video Tutorial for step-by-step instructions:
Recordsets aren't easy... this is an advanced Access developer
concept. However, I do cover them in great detail in my
Access 320 thru 329 courses. I spend over
10 hours covering Recordsets. They're important for any developer to learn
about, and once you master them, the sky's the limit with your databases!
| 
