467,211 Members | 1,217 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,211 developers. It's quick & easy.

one form for different class with different subjects

Hi

I have designed a MS Access database for progress report(grade) for students in a school.
We have different classes with different subjects.
Now I am using different forms for each section for input data.
I want to use a single form, when opened ,according to section the subject fields should change to receive the input.

Is it possible?

Pleeeeeaaaaaaaaaaase help me!

[email removed]
Feb 23 '07 #1
  • viewed: 1560
Share:
5 Replies
MMcCarthy
Expert Mod 8TB
At a guess I would say it is possible but you will have to provide a lot more information. Give the metadata for the relevant tables.
Posting Table/Dataset MetaData
Expand|Select|Wrap|Line Numbers
  1. Table Name=tblStudent
  2.  StudentID; Autonumber; PK
  3. Family; String; FK
  4. Name; String
  5. University; String; FK
  6. MaxMark; Numeric
  7. MinMark; Numeric
What tables/queries are the forms currently based on?

Mary
Feb 23 '07 #2
Hi
Thanks for caring

I have a table1 for students details

Student ID
Name
Class
Section
Etc

Another table2 for marks

EnglishMarks
PhysicsMarks
ChemistryMarks
BioMarks
CompSc.Marks
EnggDrwg.Marks

In the main form if user selects section A;

The input form should contain only
EnglishMarks
PhysicsMarks
ChemistryMarks
In the main form if user selects section B;
EnglishMarks
BioMarks
CompSc.Marks
And so on for other class.

That means every section has fixed and allotted subjects.

Now I have manually designed forms and reports for each sections, instead I am trying to find can I do with queries or other techniques.

Thanks in anticipation.
shiva
Feb 23 '07 #3
MMcCarthy
Expert Mod 8TB
Is StudentID also in the marks table?
Feb 23 '07 #4
yes, there is student ID
Feb 24 '07 #5
NeoPa
Expert Mod 16PB
To handle options like these you can include all the fields that are ever required, then, using the .Visible property of the controls on the form, you can select which ones show in any particular circumstances.
The OnCurrent event procedure should be where you place the code which will determine which controls should be shown under which circumstances.
Feb 26 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Bruce W.1 | last post: by
2 posts views Thread by Mike Button | last post: by
9 posts views Thread by Daniel Kay | last post: by
8 posts views Thread by stefano | last post: by
11 posts views Thread by Zytan | last post: by
6 posts views Thread by Thom Little | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.