Printable View
Hi, I'm doing a questionnaire in VB. It contains over 300 questions and the user has 5 options available to answer each question. i'm very new to VB and need advice on how to store these answers so they can be used in a report later.Would like to be able to view a list of unanswered questions, questions scored over 80% etc. once the questionnaire is completed. Should i store them in a database? Any help with code would be great too!
Cheers!:p
It is best to store it in a database.
What database can you access??
Help with code, what do you have and/or would you like to accomplish ?
I was thinking of creating a table in Access which would hold the questions and store the answers as the user enters them. Am using 5 option buttons to answer the questions so if the user clicks on option button1 i want a 1 to be stored in the database etc. Need coding help for this, please!
:p
Ecrypted textfile
Could you expand on that please! :p
First make a little proggie to encode a text-file using your special key (maybe do it with 'adding' ascii-codes). Then in your program decode the text-file again! That way your users can't read the aswers by just opening the files wich contains them.
Best way is to create your table with the 300 questioins in it.
Add 5 columns for each option.
When a user clicks on an option for a specifique answer increase the value for this column with one.
Be aware that when you load the form there could be one option already checked.
If more help needed, rephrase.
id have a database with a few tables.
1 with all of the questions in, with a questionID field.
1 with all of the possible answers to each question, link to above table using questionId field.
1 with all of the correct answers for each question again linked using the questionID field - (this table should have encrypted data)
1 table with the users answers etc...