Assigning one lesson to many or all students at once

[Dave White]

Hello everyone,

I would like to assign a lesson to many students as a group rather
than individually.

Any suggestions would be appreciated.

Dave White

[Steve Cartnal]

"Dave White" <dj*****@snet.netwrote in message
news:ii********************************@4ax.com...

Hello everyone,

I would like to assign a lesson to many students as a group rather
than individually.

Any suggestions would be appreciated.

Dave White

If you're saying you want to update a group of records where a field in
those records indicates that the students associated with those records are
all taking/have completed a certain lesson, I believe an update query would
do the job for you. If, however, you mean what that sentence actually says,
I would suggest that you wait until you have all the students together in
your classroom, then tell them what you want them to do. ;-)

[Dave White]

When homework or class work is assigned to students a new record is
created in the lessons table for that particular assignment.

Most, but not all, students have the same assignments.

When a student completes the assignment his grade his entered.

Presently, I must assign each student ( in the Students Table) each
lesson (from the Lessons Table).

This assignment takes place in a Junction Table.

I would like to assign each lesson on a group basis to students.

Dave White

On Sun, 11 Mar 2007 01:46:18 -0500, "Steve Cartnal"
<sc******@alltel.netwrote:

>
"Dave White" <dj*****@snet.netwrote in message
news:ii********************************@4ax.com.. .

>Hello everyone,

I would like to assign a lesson to many students as a group rather
than individually.

Any suggestions would be appreciated.

Dave White

If you're saying you want to update a group of records where a field in
those records indicates that the students associated with those records are
all taking/have completed a certain lesson, I believe an update query would
do the job for you. If, however, you mean what that sentence actually says,
I would suggest that you wait until you have all the students together in
your classroom, then tell them what you want them to do. ;-)

[Bob Quintal]

Your second post gets an A+. The previous merited an F. :-)

I would do batch assignments using an unbound form with two (2)
listboxes, one for the students, the other for the assignments,

Set the .multiselect property of the students list to simple,
Write VBA code in the assignments listbox .AfterUpdate event
which reads the students listbox, row by row, determines if the
student is or is not selected, and creates an insert query for
the student/assignment, executes the query, and loops to the
next selected student.

pseudo code example:

For each assignee in lstStudents.itemsSelected
strSQL = "Insert into StudentsAssignments"
& " (StudentID, AssignmentID)"
& "(" & lstStudents(column1,assignee)
& "," lstAssignments & ");"

sql.execute strSQL
next

Check the help entries for listbox, , specifically the
ItemsSelected and column() properties of

Dave White <dj*****@snet.netwrote in
news:9h********************************@4ax.com:

When homework or class work is assigned to students a new
record is created in the lessons table for that particular
assignment.

Most, but not all, students have the same assignments.

When a student completes the assignment his grade his entered.

Presently, I must assign each student ( in the Students Table)
each lesson (from the Lessons Table).

This assignment takes place in a Junction Table.

I would like to assign each lesson on a group basis to
students.

Dave White

On Sun, 11 Mar 2007 01:46:18 -0500, "Steve Cartnal"
<sc******@alltel.netwrote:

>>
"Dave White" <dj*****@snet.netwrote in message
news:ii********************************@4ax.com. ..

>>Hello everyone,

I would like to assign a lesson to many students as a group
rather than individually.

Any suggestions would be appreciated.

Dave White

If you're saying you want to update a group of records where a
field in those records indicates that the students associated
with those records are all taking/have completed a certain
lesson, I believe an update query would do the job for you.
If, however, you mean what that sentence actually says, I
would suggest that you wait until you have all the students
together in your classroom, then tell them what you want them
to do. ;-)

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Dave White]

Thanks for the A+ but I'm probably going to get another F .

I only have 3 months experience in Access and I haven't written any
VBA code.

You have,however ,opened some new avenues for me.

Thanks,
Dave White
On 11 Mar 2007 11:17:42 GMT, Bob Quintal <rq******@sPAmpatico.ca>
wrote:

>Your second post gets an A+. The previous merited an F. :-)

I would do batch assignments using an unbound form with two (2)
listboxes, one for the students, the other for the assignments,

Set the .multiselect property of the students list to simple,
Write VBA code in the assignments listbox .AfterUpdate event
which reads the students listbox, row by row, determines if the
student is or is not selected, and creates an insert query for
the student/assignment, executes the query, and loops to the
next selected student.

pseudo code example:

For each assignee in lstStudents.itemsSelected
strSQL = "Insert into StudentsAssignments"
& " (StudentID, AssignmentID)"
& "(" & lstStudents(column1,assignee)
& "," lstAssignments & ");"

sql.execute strSQL
next

Check the help entries for listbox, , specifically the
ItemsSelected and column() properties of

Dave White <dj*****@snet.netwrote in
news:9h********************************@4ax.com :

>When homework or class work is assigned to students a new
record is created in the lessons table for that particular
assignment.

Most, but not all, students have the same assignments.

When a student completes the assignment his grade his entered.

Presently, I must assign each student ( in the Students Table)
each lesson (from the Lessons Table).

This assignment takes place in a Junction Table.

I would like to assign each lesson on a group basis to
students.

Dave White

On Sun, 11 Mar 2007 01:46:18 -0500, "Steve Cartnal"
<sc******@alltel.netwrote:

>>>
"Dave White" <dj*****@snet.netwrote in message
news:ii********************************@4ax.com ...
Hello everyone,

I would like to assign a lesson to many students as a group
rather than individually.

Any suggestions would be appreciated.

Dave White

If you're saying you want to update a group of records where a
field in those records indicates that the students associated
with those records are all taking/have completed a certain
lesson, I believe an update query would do the job for you.
If, however, you mean what that sentence actually says, I
would suggest that you wait until you have all the students
together in your classroom, then tell them what you want them
to do. ;-)

--
Bob Quintal

PA is y I've altered my email address.