Append Assignments to Results in classroom management database

[Guest]

I am a novice to Access, and I am trying to get the classroom management
database template to do some of the things that I need it to do.

In the assignments subform, when you click on the bottom section, it
automatically adds that assignment to all of the students in the class by
running an append query.

I need it to do something similar in the student assignments subform. That
is, I need it to automatically add all of the assignments for the given class
to that student in the results table. My students work independantly on a
set curriculum, so it is more useful to enter data by student than by
assignment.

I have come pretty close, I think, by imitating the other codes, but I just
don't know the program well enough to know what I'm doing wrong. I can only
get an append query to add the assignments without any regard to what is
already in the results table, creating duplicate assignments for that
student.

I haven't really tried to get it to be automatic yet.

 

[Guest]

Hi Alternative Teacher,

If you post your code here, we'll see if we can spot what you are doing
wrong... You probably just need to limit the ones that get added to those
that don't already have a match, similar to this:

insert into tblStudentAssignment(StudentID, AssignmentID) select
me.lngStudentID as StudentID, AssignmentID from tblAssignment where
AssignmentID not in (select AssignmentID from tblStudentAssignment where
StudentID = me.lngStudentID)

Hope that makes sense...

Damian.

 

[Guest]

Actually, I was able to take what you had there, modify it a little to match
what I needed, and it worked. Thanks.

 

[Guest]

I am a novice to Access, and I am trying to get the classroom management
database template to do some of the things that I need it to do.

In the assignments subform, when you click on the bottom section, it
automatically adds that assignment to all of the students in the class by
running an append query.

I need it to do something similar in the student assignments subform. That
is, I need it to automatically add all of the assignments for the given class
to that student in the results table. My students work independantly on a
set curriculum, so it is more useful to enter data by student than by
assignment.

I have come pretty close, I think, by imitating the other codes, but I just
don't know the program well enough to know what I'm doing wrong. I can only
get an append query to add the assignments without any regard to what is
already in the results table, creating duplicate assignments for that
student.

I haven't really tried to get it to be automatic yet.