S
Slider
Hi
The situation is this. I am trying to create a way in which to record
attendance.
I have a table with a list of people called somewhat cryptically LPO (I
did not create the existing database) which contains around 200
records. Attendance for the people in this table has to be marked every
day.
What I want to do is create a form that prompts the user for a date,
then displays a list of these people, the date selected and a field to
record present/not present. I want the user to be able to enter
attendance information for each of these records and record this in
another table (called say "Attendance")
My problem is this. I am able to get this working fine for one "person"
record at a time. However, when I attempt to get it working at
described above I run into two problems.
Firstly, when I create a form that displays all the "person" records
along with fields to record attendance, a change in one of the
"attendance" fields changes all attendance fields.
Secondly, I have yet to find a way to add multiple records at the one
time. What I would ideally like to happen is for the user to enter the
information for all of the records then click an "add all" button at
the bottom that would add all of the records to the table. Currently
all I can seem to do is add one record at a time.
Is what I am after possible in Access or am I going about the problem
all wrong?
Thanks for your help
The situation is this. I am trying to create a way in which to record
attendance.
I have a table with a list of people called somewhat cryptically LPO (I
did not create the existing database) which contains around 200
records. Attendance for the people in this table has to be marked every
day.
What I want to do is create a form that prompts the user for a date,
then displays a list of these people, the date selected and a field to
record present/not present. I want the user to be able to enter
attendance information for each of these records and record this in
another table (called say "Attendance")
My problem is this. I am able to get this working fine for one "person"
record at a time. However, when I attempt to get it working at
described above I run into two problems.
Firstly, when I create a form that displays all the "person" records
along with fields to record attendance, a change in one of the
"attendance" fields changes all attendance fields.
Secondly, I have yet to find a way to add multiple records at the one
time. What I would ideally like to happen is for the user to enter the
information for all of the records then click an "add all" button at
the bottom that would add all of the records to the table. Currently
all I can seem to do is add one record at a time.
Is what I am after possible in Access or am I going about the problem
all wrong?
Thanks for your help