Assigning one lesson to many or all students at once

Assigning one lesson to many or all students at once

Post by Dave Whit » Mon, 12 Mar 2007 11:53:08


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
 
 
 

Assigning one lesson to many or all students at once

Post by Steve Cart » Mon, 12 Mar 2007 15:46:18


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. ;-)

 
 
 

Assigning one lesson to many or all students at once

Post by Dave Whit » Mon, 12 Mar 2007 19:40:09

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"
 
 
 

Assigning one lesson to many or all students at once

Post by Bob Quinta » Mon, 12 Mar 2007 20:17:42

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 < XXXX@XXXXX.COM > wrote in








--
Bob Quintal

PA is y I've altered my email address.

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

Assigning one lesson to many or all students at once

Post by Dave Whit » Tue, 13 Mar 2007 07:40:39

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 < XXXX@XXXXX.COM >