473,320 Members | 1,936 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,320 software developers and data experts.

Before I start - can this be done? (easily)

I am thinking about attempting a program to help my colleagues at
school to write their pupil reports. Each report has two sections: a
list of skills with a seies of tick boxes to show the level reached,
and an area to write a comment underneath. Each subject is slightly
different in the number of skills and their description and therefore
the position of the eomment is slightly different. I realise that I
can create different forms to resemble the layout of the different
reports and I can link these to a database to save the data. However
entering the information is not the problem.

What I want to be able to do review the reports for an individual
pupil so that as I move through their records the appropriate form is
used to display each subject. Is is possible to have a field in the
database that stores the subject name and therefore makes it possible
to view the record with the form that has been used to create it. In
other words, with a particular pupil selected it will use the History
form to show the history report and the maths form to display the
maths report and it seemlessly goes from one to the other as you cycle
through them. Obviously I will also need to print out the records for
each subject using the appropriate style of report.

Is this possible?

Is there a better way?

Thanks in advance - it will help an overworked teacher.

Jonathan Smith

Nov 20 '05 #1
5 973
I would use a tab control instead of popping up different forms for each
subject. That way you can just clicked back and forth
between subjects. Just a thought.
"Jonathan Smith" <j.*******@breathe.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
I am thinking about attempting a program to help my colleagues at
school to write their pupil reports. Each report has two sections: a
list of skills with a seies of tick boxes to show the level reached,
and an area to write a comment underneath. Each subject is slightly
different in the number of skills and their description and therefore
the position of the eomment is slightly different. I realise that I
can create different forms to resemble the layout of the different
reports and I can link these to a database to save the data. However
entering the information is not the problem.

What I want to be able to do review the reports for an individual
pupil so that as I move through their records the appropriate form is
used to display each subject. Is is possible to have a field in the
database that stores the subject name and therefore makes it possible
to view the record with the form that has been used to create it. In
other words, with a particular pupil selected it will use the History
form to show the history report and the maths form to display the
maths report and it seemlessly goes from one to the other as you cycle
through them. Obviously I will also need to print out the records for
each subject using the appropriate style of report.

Is this possible?

Is there a better way?

Thanks in advance - it will help an overworked teacher.

Jonathan Smith

Nov 20 '05 #2
Well, first of all the form you use to view the records will be bound to the
data, therfore if you were scrolling through the records using a curson down
key for example on a datagrid, you could not expect the current form to be
changed as you would loose the bindings etc.

However, One way ( and Im sure there are others ), is to load hidden forms
for the different reports and for each record selected, fill the hidden
form;s fields with the record data. If you wanted to change the data then
you would need to update the datagrid control bound to the dataset.

So in essence, the answer is yes, even if a little messy.

Interestingly enough, the first thing which came to mind when I read your
post was Lotus Domino. records ( notes ), This could have really easilly
done what you wanted. But hey, were not here to discusss notes.

Regards - OHM#

Jonathan Smith wrote:
I am thinking about attempting a program to help my colleagues at
school to write their pupil reports. Each report has two sections: a
list of skills with a seies of tick boxes to show the level reached,
and an area to write a comment underneath. Each subject is slightly
different in the number of skills and their description and therefore
the position of the eomment is slightly different. I realise that I
can create different forms to resemble the layout of the different
reports and I can link these to a database to save the data. However
entering the information is not the problem.

What I want to be able to do review the reports for an individual
pupil so that as I move through their records the appropriate form is
used to display each subject. Is is possible to have a field in the
database that stores the subject name and therefore makes it possible
to view the record with the form that has been used to create it. In
other words, with a particular pupil selected it will use the History
form to show the history report and the maths form to display the
maths report and it seemlessly goes from one to the other as you cycle
through them. Obviously I will also need to print out the records for
each subject using the appropriate style of report.

Is this possible?

Is there a better way?

Thanks in advance - it will help an overworked teacher.

Jonathan Smith


Regards - OHM# On**********@BTInternet.com
Nov 20 '05 #3
Cor
Hi Jonathan,

I would first look for this if I was you.
http://www.microsoft.com/products/in...30876&type=ovr
Cor
I am thinking about attempting a program to help my colleagues at
school to write their pupil reports. Each report has two sections: a
list of skills with a seies of tick boxes to show the level reached,
and an area to write a comment underneath. Each subject is slightly
different in the number of skills and their description and therefore
the position of the eomment is slightly different. I realise that I
can create different forms to resemble the layout of the different
reports and I can link these to a database to save the data. However
entering the information is not the problem.

What I want to be able to do review the reports for an individual
pupil so that as I move through their records the appropriate form is
used to display each subject. Is is possible to have a field in the
database that stores the subject name and therefore makes it possible
to view the record with the form that has been used to create it. In
other words, with a particular pupil selected it will use the History
form to show the history report and the maths form to display the
maths report and it seemlessly goes from one to the other as you cycle
through them. Obviously I will also need to print out the records for
each subject using the appropriate style of report.

Nov 20 '05 #4
"Jonathan Smith" <j.*******@breathe.com> wrote...
What I want to be able to do review the reports for an individual
pupil so that as I move through their records the appropriate form is
used to display each subject. Is is possible to have a field in the
database that stores the subject name and therefore makes it possible
to view the record with the form that has been used to create it.


Jonathan... I don't know why everybody has gone off deep end on this one.
The answer seems to be "yes." You would check the field (that indicates
which form to use) and display the appropriate form with that data.

I'm not going to suggest a UI but a tab control (as suggested) seems
entirely wrong. You can "morph" the display form as the record pointer is
moved into the correct one for viewing each report. It seems like a fun
project to write.

Tom
Nov 20 '05 #5
"Tom Leylan" <ge*@iamtiredofspam.com> wrote...
I'm not going to suggest a UI but a tab control (as suggested) seems
entirely wrong. You can "morph" the display form as the record pointer is
moved into the correct one for viewing each report. It seems like a fun
project to write.


Oops... I better clarify that.

It's not that you shouldn't use a tab control but rather that you wouldn't
want visible tabs such that the user has to select the proper one. The
"morphing" could be as easy as the proper tab being selected automatically.
You just don't want to actually see the tabs.
Nov 20 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

17
by: Noam Raphael | last post by:
Hello, Many times I find myself asking for a slice of a specific length, and writing something like l. This happens both in interactive use and when writing Python programs, where I have to write...
4
by: Jonathan Smith | last post by:
I am thinking about attempting a program to help my colleagues at school to write their pupil reports. Each report has two sections: a list of skills with a seies of tick boxes to show the level...
7
by: PC Datasheet | last post by:
Looking for suggestions ---- A database was designed for a national automobile inspection program. In it's simplest form, the database has two tables: TblOwner OwnerID <Year/Make/Model owned...
6
by: Dmitri Shvetsov | last post by:
Hi, Can I start an external process from the Web Service? I'm using a code, compiler keeps silence, compiles ok and starts the project. When I trace in Debugger it doesn't start an external...
5
by: Stan Shankman | last post by:
C# -- Visual Studio.Net – Windows Application Greetings all, How do I copy a Form’s image to a bitmap? – And do so before it gets to the screen. I haven’t been able to find anyone that knows...
3
by: Kiran | last post by:
Hi, Was wondering if its possible to have a event notification in Thread when the thread is about to start and the thread has just finished doing its work and about to terminate. If its not...
7
by: Mike | last post by:
So, I've been trying to do "MyFirstVBWebApp" and I am hitting numerous roadblocks. After much google'ing, here is what I have done (XP Pro SP1, IIS 5.1) 1. Uninstalled IIS 2. renamed the...
0
by: WATYF | last post by:
This is my problem... I have some code that starts a Process and returns it to a variable... (prcBat) At any time while that process is running... I want to be able to Kill it by pressing a...
5
by: Chris | last post by:
What would be the simplest way to make an app wait for one process to finish before starting the next process? Example /// FileCopy(strPath & "test.mdb", strPath & "live.mdb") Wait(Until...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.