How do I create this form?

[Sean]

I made myself (what I think is a nice, little) database to use as my grade
book... very simple but extremely useful, especially for reporting. Here is
my problem.

I want to create a form where I can use a combo box to pull up a student and
then another combo box to pull up an assignment and then enter the student's
score. This is what I have so far:

[tblStudent]
StudentID (PK) (Incemental, autonumber since this won't get to large to
maintain)
StudentSSN
StudentLastName
StudentFirstName
etc, etc, ......

[tblAssignment]
AssignmentID (PK)
AssignmentDescription
AssignmentTotalPoints
AssignmentType

[tblStdntAsgmntRecursive]
StdntAsgmntID (PK)
StudentID
AssignmentID
PointsEarned

OK, now, I have tried just about every Wizard and dataset I can think of to
use for the form, but I can't get this to work.

I have the recursive table because one student will have many assignments
and each assignment will have many students... is this the problem? If it
is, how do I work around this? I am not averse to coding, but I am having a
severe brain-drain week and I cannot get this off the ground. Any help is
greatly appreciated. THANK YOU.

 

[Rick B]

I've never used it, but before you go too far down this road, you might want
to look at the template on the Microsoft website. It may do everything you
are trying to accomplish and more.

Templates > Microsoft Office Programs > Access > Education

 

[Sean]

Rick, thanks, but I did try the template and it does not do what I want. It
is too complex - I understand it, but it uses far too many forms and subforms
to do one operation since it is designed from an administration
point-of-view... Multiple teachers, multiple classes.

I just want to "drop-down" on Sally, and "drop-down" on Test #1 and enter
the grade.

Any other ideas? I tried to extrapolate from basic idea from this template
but because it is designed from this other POV I can't tell what I need and
what I can leave out.

Thanks

I've never used it, but before you go too far down this road, you might want
to look at the template on the Microsoft website. It may do everything you
are trying to accomplish and more.

Templates > Microsoft Office Programs > Access > Education



--
Rick B

I made myself (what I think is a nice, little) database to use as my grade
book... very simple but extremely useful, especially for reporting. Here is
my problem.

I want to create a form where I can use a combo box to pull up a student and
then another combo box to pull up an assignment and then enter the student's
score. This is what I have so far:

[tblStudent]
StudentID (PK) (Incemental, autonumber since this won't get to large to
maintain)
StudentSSN
StudentLastName
StudentFirstName
etc, etc, ......

[tblAssignment]
AssignmentID (PK)
AssignmentDescription
AssignmentTotalPoints
AssignmentType

[tblStdntAsgmntRecursive]
StdntAsgmntID (PK)
StudentID
AssignmentID
PointsEarned

OK, now, I have tried just about every Wizard and dataset I can think of to
use for the form, but I can't get this to work.

I have the recursive table because one student will have many assignments
and each assignment will have many students... is this the problem? If it
is, how do I work around this? I am not averse to coding, but I am having a
severe brain-drain week and I cannot get this off the ground. Any help is
greatly appreciated. THANK YOU.

 

[Rick B]

No ideas here, just thought I'd offer that suggestion. I'm sure someone can
help you with your original post.


--
Rick B

Rick, thanks, but I did try the template and it does not do what I want. It
is too complex - I understand it, but it uses far too many forms and subforms
to do one operation since it is designed from an administration
point-of-view... Multiple teachers, multiple classes.

I just want to "drop-down" on Sally, and "drop-down" on Test #1 and enter
the grade.

Any other ideas? I tried to extrapolate from basic idea from this template
but because it is designed from this other POV I can't tell what I need and
what I can leave out.

Thanks

I've never used it, but before you go too far down this road, you might want
to look at the template on the Microsoft website. It may do everything you
are trying to accomplish and more.

Templates > Microsoft Office Programs > Access > Education



--
Rick B

I made myself (what I think is a nice, little) database to use as my grade
book... very simple but extremely useful, especially for reporting.

Here
is

my problem.

I want to create a form where I can use a combo box to pull up a

student
and

then another combo box to pull up an assignment and then enter the student's
score. This is what I have so far:

[tblStudent]
StudentID (PK) (Incemental, autonumber since this won't get to large to
maintain)
StudentSSN
StudentLastName
StudentFirstName
etc, etc, ......

[tblAssignment]
AssignmentID (PK)
AssignmentDescription
AssignmentTotalPoints
AssignmentType

[tblStdntAsgmntRecursive]
StdntAsgmntID (PK)
StudentID
AssignmentID
PointsEarned

OK, now, I have tried just about every Wizard and dataset I can think

of
to

use for the form, but I can't get this to work.

I have the recursive table because one student will have many assignments
and each assignment will have many students... is this the problem? If it
is, how do I work around this? I am not averse to coding, but I am

having
a

severe brain-drain week and I cannot get this off the ground. Any help is
greatly appreciated. THANK YOU.

 

[BruceM]

Maybe a main form (frmStudent) based on tblStudent, and a subform
(fsubStdntAsgmnt) based on tblStdntAsgmntRecursive. fsubStdntAsgmnt could
have a combo box bound to AssignmentID, and frmStudent could have a combo
box with tblStudent as its row source for selecting a record based on the
combo box value. The combo box wizard can provide the basic structure, if
you like. What I am thinking is that you could select a student, then
select an assignment, but you could do it the other way around by having the
main form based on tblAssignment. That may be preferable, as tblStudent is
likely to be fairly static after the beginning of the school year, while
tblAssignment will be more active.
The thing I can't see is how to have a single form where you could select
either a student and see all of his or her assignments, or select an
assignment and see all of the students assigned to it. If I had to do both
I would probably use two separate forms, with a command button on the other
form or maybe a switchboard to go from one to the other. In my case I have
training records. I enter training records on the main form, and attendees
on a subform bound to a junction table. Employee names are selected from a
combo box on the subform that has tblEmployees as its row source. To see an
individual employee records I use a report grouped by Employee, but I expect
you could use a form instead.

Rick, thanks, but I did try the template and it does not do what I want.
It
is too complex - I understand it, but it uses far too many forms and
subforms
to do one operation since it is designed from an administration
point-of-view... Multiple teachers, multiple classes.

I just want to "drop-down" on Sally, and "drop-down" on Test #1 and enter
the grade.

Any other ideas? I tried to extrapolate from basic idea from this
template
but because it is designed from this other POV I can't tell what I need
and
what I can leave out.

Thanks

I've never used it, but before you go too far down this road, you might
want
to look at the template on the Microsoft website. It may do everything
you
are trying to accomplish and more.

Templates > Microsoft Office Programs > Access > Education



--
Rick B

I made myself (what I think is a nice, little) database to use as my
grade
book... very simple but extremely useful, especially for reporting.
Here is
my problem.

I want to create a form where I can use a combo box to pull up a
student and
then another combo box to pull up an assignment and then enter the student's
score. This is what I have so far:

[tblStudent]
StudentID (PK) (Incemental, autonumber since this won't get to large to
maintain)
StudentSSN
StudentLastName
StudentFirstName
etc, etc, ......

[tblAssignment]
AssignmentID (PK)
AssignmentDescription
AssignmentTotalPoints
AssignmentType

[tblStdntAsgmntRecursive]
StdntAsgmntID (PK)
StudentID
AssignmentID
PointsEarned

OK, now, I have tried just about every Wizard and dataset I can think
of to
use for the form, but I can't get this to work.

I have the recursive table because one student will have many
assignments
and each assignment will have many students... is this the problem? If
it
is, how do I work around this? I am not averse to coding, but I am
having a
severe brain-drain week and I cannot get this off the ground. Any help
is
greatly appreciated. THANK YOU.