Visual Basic Help! - HELP! please

Fa1nT

Fa1nT

Fa1nT

Associate
Joined
25 Sep 2003
Posts
116
Location
Torquay
Ive been assigned a project to create a data base in VB. I have no idea how to so i need any help or advise you guys can give me!

I need to .

Design an Input screen which allows...

Students Name
Class Number
Subject
Marks for subject
Total Marks
Grade of total marks .. i.e distinction , merit , fail , pass

and an output screen to display the data .

any help , abuse , advise ...appreicated!

darren
 
Homework eh? This is very simple. A few hours of reading on VB and you would have this done. Also, I would pay attention to your tutor in future. :p

Another thing, you have mentioned if this for VB 6 or VB.NET.
 
Last edited:
Its VB 6.0

Ive tried reading a few tutorials but nothings helped so far .

Arghhhhhhhhhhhhhhhhhhhhhhhhhhh!
 
Thats really easy, you could do it with InputBoxes and then display them on the form using code for example:

If the input box for Student Name was called StudentName -

StudentNameLbl.Caption = StudentName

Something like that - i havent used VB in a while.

You can also use Text Boxes and allow only certain things, for example in the Grade have a drop down to have D, M, P, F etc.

Hope this helps, if not..sorry :p
 
Lots of ways to do this, it all really depends on your skill level as to what method is best.

Best thing to do is break down the problem and ask specific questions that can easily be answered and go from there.
 
I shall do that ! :D Ive watched around 10 tuturials on youtube last night , some were very helpful .
 
My assignment is ...

You will design an input screen that will allow the following the user to input the following ...

Student Initial
Student Surname
Class Number
Subject
Marks for subjects
Total Marks
Grade of total marks

to aim for high marks the data entry need to be clear and well laid out and suitably labelled with correct validation of input and error messages to the user.

you will then design an output form with the final grades.

WTF!!!!!! im so stuck its unreal .

anyhelp ! any help is much much appreciated ! im not asking someone to do it for me just point me in the right directions! <3 love you !

darren .
 
lol man. :p First have you designed your input screen yet in VB. Please tell me you have? It's friggin simple just drag and drop the controls onto the form.
 
Yeah Im like making a small one , im having problems coding it .

help2.jpg


visualbasichelp.jpg


Im just clueless as to how to save the information and enter it arghhhh . remember this is the first time ive evenb looked at this program.
 
Does this information have to be stored in a database or do you want to pass it from one form to another?
 
Fa1nT said:
...

Im just clueless as to how to save the information and enter it arghhhh . remember this is the first time ive evenb looked at this program.
Click to expand...

:eek: someone realy should have been paying attention, this is very basic stuff and will have been coverd in class.


1st you sould of created a database using normalisation, this will be used to store and recall your data.

2nd design the input form based on the database like noob said this is just drag and drop (if you need help on how to use some of the more advanced controls im happy to help)

3rd use whatever method thay taught you to store and fill the form from the db. (This will involve opening a connection to you db and running sql on it, again if you are having trouble with im happy to help you debug)



I know this is harsh but if you realy cant do the above you need to talk to your tutor asap.

Ive got a rule never do someone elses work for them.
 
Some hints, look at your notes for the following.


1) Normalisation
2) ADO or DAO
3) Sql statments (select,update,insert,delete)

Think about the layout

4) What type of data being used. If its a list use a list box. If its a yes no type thing use a check box. If its a table use a list view. ect.
5) dont forget your not limited to one form, you can show forms to enter or display data (ie class and grades).
6)Validation, this can be tricky but using the right types of inputs can solve most of your problems. If you need help doing specific types of validation let us know.
7) Dont forget tab stops.
 
Last edited:
Shadez I think you are wasting your time unfortunately, from what I can tell he hasn't turned up to one lesson. ;) :eek:

I don't think he really understands what is required for his assignment.

Fa1nT said:
Ive been assigned a project to create a data base in VB.
Click to expand...

For a start you don't create a database in VB you create it in Access, etc. This is the only comment he has made that indicates that his tutor wants what you explained in your latest post. But that's a big assumption on my part. :p
 
No guys , Autually Im doing an access course and the tutor is not very helpful attall , he gives us handouts and basically makes us get on with it , im not going to go into the whole college situtation but this is helping me a lot. I am also trying very hard to get this done , I dont have to create a database Its basically an Input and Output form , I misunderstood the sheet.

From the example noob gave me ive learnt more about the coding side .

Now on the input form I have to somehow ..

Allow input for test scores in

English
Maths
Science
History

I thought i would create labels for the subjects then text box's to display the scores . It then has to display the total scores and with this information which im finding very difficult at the moment as I have so little knowledge of VB..

0-36 Marks - Fail
40-55 Pass
56-70 Merit
70+ Distinction

i think i need to learn some sort of IF or OR statement so that on the output it will automatically display the grade once i have entered the score. Im not sitting on my ass waiting for you guys i am google'ing away and will be taking a trip to the library tomorrow , but i find that asking people is a much better way to attack the problem .

cheers everyone so far !
 
Its ok faint i understand about usless tutors i had one for gcse biology (dam that was a long time ago now) you could always make a complaint about the teacher you never know what might happen.

Im trying not to give you the answers, but let you make the design desisions right or wrong and just help you make the best of it.


This should give you some help creating the fail-distinction box

Code: 
if text1.text <= 36 then
    text2.text = "Fail"
elseif text1.text <=55 then
    text2.text = "Pass"
elseif text1.text >=70 then
    text2.text = "Dist"
end if

or you might want to use a select case instead
Code: 
select text1.text
     case 0 to 36
        text2.text = "Fail"
     case 37 to 55 
        text2.text = "Pass"
     case >=70    
        text2.text = "Dist"
end select

Also play with the IsNumeric() function in the marks text boxes validation event, and set the locked property of textboxes you dont want people to type in.
 
Last edited:
What Shadez said and to total the scores something like: -

txtTotal.Text = cint(Text2.text) + cint(Text3.text)

etc, etc.
 
You must log in or register to reply here.
Back
Top Bottom