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
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!
By Richard Rost
Click here to sign up for more FREE tips