473,396 Members | 1,689 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

one form for different class with different subjects

3
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
5 1732
MMcCarthy
14,534 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
shivak
3
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
14,534 Expert Mod 8TB
Is StudentID also in the marks table?
Feb 23 '07 #4
shivak
3
yes, there is student ID
Feb 24 '07 #5
NeoPa
32,556 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

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

Similar topics

1
by: Bruce W.1 | last post by:
I'm new to ASP (but not ASP.NET) and I'm trying to setup a simple ASP web form to send an email to me. So I try this code: http://www.library.unr.edu/subjects/guides/mailplay.asp I upload the...
2
by: Mike Button | last post by:
Hello all, I am really really desperate on what I should do, and I am asking for help from anyone in this newsgroup, here's the situation: I am creating a form that is being run on a server...
9
by: Daniel Kay | last post by:
Hello! I have written two template classes which implement the observerpattern in C++. I hope I manage to desribe the problem I have. template<class T> class Observer { /* ... */ }; ...
15
by: Paul T. Rong | last post by:
Hi everybody, This time a very very difficult case: I have a table "tblStudent", there are 50 students, I also made a form "frmStudent" based on "tblStudent", now if I don't want to show all...
8
by: stefano | last post by:
HI, I have aproblem with XHTML radio button. <form name=" form"> <input name="radio" type="radio" onclick="return false" /> <input name="radio" type="radio" onclick="return false" /> <input...
17
by: radio1 | last post by:
Configuration: Access 2002 and SQL Server 2000 using a .ADP Project. I would VERY MUCH appreciate anyone's input into this problem I'm having. I have a form in Access that does not permit...
7
by: markymark34 | last post by:
I have a form that allows examiners to be assigned to a particular centre. So for example i have 10 examiners who all examine different subjects and i have 5 centres one of which is doing an exam in...
11
by: Zytan | last post by:
I have created a new form from the main form. When I close the main form with the 'x' close button, its Form.FormClosed event is run, but not the dialog's. Is this normal? It is ok /...
6
by: Thom Little | last post by:
Using C# 3.5 I have a form that calls many other sub-forms. Typically there will be five forms open at the same time. If the main form is closed all the sub forms are also closed. Is there...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.