B
bladernr
OK, so now I made the application I'm working on a little more complex.
My client changed the spec on me a bit and it seems that the only easy
way to do what they want is to use some sub forms.
What I am working on is a database app in Access that will store
faculty information like ID, Name, credentials, classes taught, grad
hours taken, and so forth. The biggest problem I had was that the form
that they were using historically was a paper form that was not easily
transcribed to electronic means without becomming unweildy. I fixed
that problem using a tab structure.
Basically, for each faculty member, that person could be teaching in
several different disciplines such as: University Transfer,
Non-Transfer, Phys Ed, Basic Skills, Community Outreach (Con Ed),
Developmental (ESL, Reading for illeterates, basic Math skills, GED,
etc). For each of thsoe disciplines, they could be teaching several
different classes. (more like only one, but thats how it works).
So, the teacher could have one class in the University Transfer
discipline, One class under Non-Transfer, and 2 classes under Basic
Skills.
So, I have a tab for each discipline, and the administration only fills
out the appropriate tabs. NOW. For courses assigned, I am using a
seperate table and a sub form in each tab. The layout for each tab
looks something like this:
|University Transfer|
----------------------------------------------------------------------------------------------------------------------------------------------
Highest applicable credential: [DROP DOWN BOX OF DEGREES (MA, BS, AS,
DIP, LICENSE)]
Highest credential applied: [TEXT for their actual credentail (M.A. -
Eng from UNC Chapel Hill)]
----------------------------------------------------------- 18
Graduate Hours: Additional Qualifications:
SUB FORM | [TEXT BOX TO LIST]
[TEXT BOX TO LIST ANY ]
ENG 111 Intro English T (transfer) | [GRAD COURSES ]
[ADDITIONAL QUALS. ]
ENG 114 American Lit T (transfer) | [TAKEN ]
[ ]
-----------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------
That is a VERY poor diagram of the basic layout. What I am trying to
figure out, however, is how to do the sub form for each tab. What I
want is for the sub form in the Univ. Tranfer tab to only display
assigned courses that are for that discipline, and the sub form in the
Phys Ed discipline to only display assigned courses that are phys ed
and so on.
Currently, I have a secondary table that holds courses assigned by
Faculty ID number. The basic lay out is like this:
ID (Id number), Discipline (ENG, PHY, MAT, etc), CourseNo (111, 112,
114), CourseTitle (30 char text), NDT (N for nontransfer, T for
transfer, D for developmental).
I thought the best way to do this would be to add an additional field
to this table to differentiate the type of course.
So the real question is, how do I tell the sub form to only display the
correct courses? Right now its just using the table for data as a
proof of concept. Eventually, I need to base that subform on queries.
But how to I query that table and pass the tab that owns the sub form
as a parameter?? VBA? or is there some magic that will allow that to
work.
Did that even make sense? Anyone wiht some wisdom to help a guy out?
Cheers
Jeff
My client changed the spec on me a bit and it seems that the only easy
way to do what they want is to use some sub forms.
What I am working on is a database app in Access that will store
faculty information like ID, Name, credentials, classes taught, grad
hours taken, and so forth. The biggest problem I had was that the form
that they were using historically was a paper form that was not easily
transcribed to electronic means without becomming unweildy. I fixed
that problem using a tab structure.
Basically, for each faculty member, that person could be teaching in
several different disciplines such as: University Transfer,
Non-Transfer, Phys Ed, Basic Skills, Community Outreach (Con Ed),
Developmental (ESL, Reading for illeterates, basic Math skills, GED,
etc). For each of thsoe disciplines, they could be teaching several
different classes. (more like only one, but thats how it works).
So, the teacher could have one class in the University Transfer
discipline, One class under Non-Transfer, and 2 classes under Basic
Skills.
So, I have a tab for each discipline, and the administration only fills
out the appropriate tabs. NOW. For courses assigned, I am using a
seperate table and a sub form in each tab. The layout for each tab
looks something like this:
|University Transfer|
----------------------------------------------------------------------------------------------------------------------------------------------
Highest applicable credential: [DROP DOWN BOX OF DEGREES (MA, BS, AS,
DIP, LICENSE)]
Highest credential applied: [TEXT for their actual credentail (M.A. -
Eng from UNC Chapel Hill)]
----------------------------------------------------------- 18
Graduate Hours: Additional Qualifications:
SUB FORM | [TEXT BOX TO LIST]
[TEXT BOX TO LIST ANY ]
ENG 111 Intro English T (transfer) | [GRAD COURSES ]
[ADDITIONAL QUALS. ]
ENG 114 American Lit T (transfer) | [TAKEN ]
[ ]
-----------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------
That is a VERY poor diagram of the basic layout. What I am trying to
figure out, however, is how to do the sub form for each tab. What I
want is for the sub form in the Univ. Tranfer tab to only display
assigned courses that are for that discipline, and the sub form in the
Phys Ed discipline to only display assigned courses that are phys ed
and so on.
Currently, I have a secondary table that holds courses assigned by
Faculty ID number. The basic lay out is like this:
ID (Id number), Discipline (ENG, PHY, MAT, etc), CourseNo (111, 112,
114), CourseTitle (30 char text), NDT (N for nontransfer, T for
transfer, D for developmental).
I thought the best way to do this would be to add an additional field
to this table to differentiate the type of course.
So the real question is, how do I tell the sub form to only display the
correct courses? Right now its just using the table for data as a
proof of concept. Eventually, I need to base that subform on queries.
But how to I query that table and pass the tab that owns the sub form
as a parameter?? VBA? or is there some magic that will allow that to
work.
Did that even make sense? Anyone wiht some wisdom to help a guy out?
Cheers
Jeff