MSGBOX "FAILED"

[lee123]

I have a form I have been working on and now I am almost done with it but there is just one thing I need to finish it that I can figure out. Well I have a questionnaire form with 50 questions and I want to have a msgbox display at the end of the questionnaire "failed" or "passed" when the users have finished the test. On this form I have text boxes with "correct' and "incorrect" and a text box for the total percentage of the correct. This is what I got in codes:

FOR THE "CORRECT" TEXTBOX THE CODE I HAVE PUT IN THE CONTROL SOURCE IS THIS,

 
=IIf([CHECK4],1,0)+IIf([CHECK16],1,0)+IIf([check22],1,0)
+IIf([CHECK46],1,0)+IIf([CHECK33],1,0)+IIf([CHECK58],1,0)
+IIf([check73],1,0)+IIf([check103],1,0)+IIf([CHECK112],1,0)
+IIf([CHECK150],1,0)+IIf([CHECK153],1,0)
 

FOR THE "INCORRECT" I HAVE PRETTY MUCH THE SAME:

=IIf([CHECK6],1,0)+IIf([CHECK8],1,0)+IIf([CHECK14],1,0)
+IIf([check12],1,0)+IIf([check20],1,0)+IIf([check28],1,0)
+IIf([CHECK30],1,0)+IIf([CHECK37],1,0)+IIf([CHECK39],1,0)
+IIf([CHECK41],1,0)+IIf([CHECK43],1,0)+IIf([CHECK56],1,0)
+IIf([check65],1,0)+IIf([check67],1,0)+IIf([check71],1,0)
+IIf([check105],1,0)+IIf([check108],1,0)+IIf([check101],1,0)
+IIf([CHECK119],1,0)+IIf([CHECK148],1,0)
 

FOR THE PERCENTAGE TEXTBOX THIS IS WHAT I HAVE:

=[CORRECT]/50


THIS IS JUST A LITTLE BIT OF THE CODES I HAVE NOT INCLUDING THE CHECKBOXES FOR THE ANSWERS WELL IF IT HELPS THIS IS ONE OF THE CHECKBOX CODE FOR THE INCORRECT:

      If Check12 = Check12 Then
        Check12.Enabled = True
        Check14.Enabled = False
        Check16.Enabled = False
        Check12.Locked = True
    MsgBox "INCORRECT! THE CORRECT ANSWER IS 40 HRS"
End If

Well this is just about what I have, but my question is how can I put a msgbox at the end of all of this that replies "failed" or "passed" or if the user gets so many questions wrong the message box would pop up with "failed"

This is probably too much right ?

LEE123

[tdw]

I don't know if it's just my browser or what, but your post is very difficult to read.
could you please try reposting it without all the caps, and use the CODE tags around the code, as is explained in the little yellow box to the right of the typing window? Thanks

[lee123]

ok i have a form i have been working on and now im almost done with it i have made a driving written test with 50 questions on it and the only thing i need is some kind of msgbox or a lable that pops up when the user gets done with the test. that displays either "failed" or "pass". i want to know if i can base this message on the incorrect textbox so if the user gets so many wrong the words "failed" would pop up. otherwise it would say "passed" the codes i have for the two textboxes is:

for the correct textbox i have this:

=iif(checkboxname,1,0)+iif(checkboxname,1,0)

there is alot of them.

the incorrect textbox i have:

=iif(checkboxname,1,0)+iif(checkboxname,1,0)

for the checkboxes the code behind it is:

 If ANSWER2 = ANSWER2 Then
        ANSWER2.Enabled = True
        ANSWER1.Enabled = False
        ANSWER3.Enabled = False
        ANSWER2.Locked = True
    msgbox ("CORRECT!")

i don't know if i did this right but all of it works i just need to know how i can get the "failed" to pop up either in a msgbox or lbl if they get to many wrong.
can you help me.

ps i never knew how to make the tags work but now i know thanks.

lee123

[tdw]

ok i have a form i have been working on and now im almost done with it i have made a driving written test with 50 questions on it and the only thing i need is some kind of msgbox or a lable that pops up when the user gets done with the test. that displays either "failed" or "pass". i want to know if i can base this message on the incorrect textbox so if the user gets so many wrong the words "failed" would pop up. otherwise it would say "passed" the codes i have for the two textboxes is:

for the correct textbox i have this:

=iif(checkboxname,1,0)+iif(checkboxname,1,0)

there is alot of them.

the incorrect textbox i have:

=iif(checkboxname,1,0)+iif(checkboxname,1,0)

for the checkboxes the code behind it is:

 If ANSWER2 = ANSWER2 Then
        ANSWER2.Enabled = True
        ANSWER1.Enabled = False
        ANSWER3.Enabled = False
        ANSWER2.Locked = True
    msgbox ("CORRECT!")

i don't know if i did this right but all of it works i just need to know how i can get the "failed" to pop up either in a msgbox or lbl if they get to many wrong.
can you help me.

ps i never knew how to make the tags work but now i know thanks.

lee123

Does your test form pop up a single question at a time? If so, once the next question comes up, is there anything remembering what they had answered on the last or previous questions, i.e. a new record in a table or something?

[lee123]

to answer your question no the questions are on the form i used a label for the questions and however many check boxes i needed for the answers sorta like this:

(question):
how many hrs does a person under 17 have to complete before driving:


(answers)

checkbox 1
checkbox 2
checkbox 3
checkbox 4

there all in a colunm going from top to bottom does that make any sense or
should i' ve done something different?

i guess to understand your question it would be like this: if you had a piece of paper and numbered question 1 question 2 and question 3 down the paper thats what it would look like and had the answers under the questions like a,b.or c
multiple choice.

lee123

[lee123]

if the user picks a wrong answer the other answers are disabled so they can't change there mind but if the user picks the right answer the others disappear leaving only the right answer.

[tdw]

if the user picks a wrong answer the other answers are disabled so they can't change there mind but if the user picks the right answer the others disappear leaving only the right answer.

So all of the questions are on the form at the same time, like a full sheet of test questions? And once the student clicks on an answer, whether right or wrong, they cannot change their answer?
I'm learning Access as I go here, and I'm no expert yet. Since I have received so much help on this forum I like to try to help where I can. I have an idea though, see what you think (and what others on the forum think):

Maybe if you have a variable that counts up +1 every time a question is answered wrong, then every time it adds one to the variable it checks to see if it has reached the max limit of allowable wrong answers... then when it reaches it, it displays the FAILED LOSER!! (or something) message box and ends the test. If you're not sure how to do this and no one else has a better way, please let me know.

[NeoPa]

Lee,
Your code for correct is ok, but your code for incorrect should be of the form :

=IIf(FirstCorrectCheckBox, 0, 1)+IIf(SecondCorrectCheckBox, 0, 1)+...

not

=IIf(FirstWrongCheckBox, 1, 0)+IIf(SecondWrongCheckBox, 1, 0)+...

NB The order of the 1s & the 0s.

[lee123]

yea i'm not that good at variables i mean everytime i try it never works i see how it looks in my head but when i attempt it, it never works variables to me are tricky i've tried to do one and i don't get how they work so i don't know how to do this, i've tried the if ....then statement but nothing i wanted to try to use the iif with the incorrect code but nothing.

lee123

[oldroboman]

yea i'm not that good at variables i mean everytime i try it never works i see how it looks in my head but when i attempt it, it never works variables to me are tricky i've tried to do one and i don't get how they work so i don't know how to do this, i've tried the if ....then statement but nothing i wanted to try to use the iif with the incorrect code but nothing.

lee123

try something simple

dim counter as long
counter = 0

then after each question,
if answer = correct then counter = counter +1

and so on?

[oldroboman]

yea i'm not that good at variables i mean everytime i try it never works i see how it looks in my head but when i attempt it, it never works variables to me are tricky i've tried to do one and i don't get how they work so i don't know how to do this, i've tried the if ....then statement but nothing i wanted to try to use the iif with the incorrect code but nothing.

lee123

try something simple

      dim counter as long
 
      counter = 0

then after each question,

      if answer = incorrect then counter = counter +1
      if counter = maxfail then 
      msgbox("Better luck next time")
      exit 

and so on?

[oldroboman]

Appoligies for the multi post, I accidently tabbed on the submit button, didn't realise you can't tab in this box!! sorry

[NeoPa]

Apologies for the multi post, I accidently tabbed on the submit button, didn't realise you can't tab in this box!! sorry

No problem & thanks for explaining. I whipped out the second copy so it reads better now.

With reference to your solution, remember that the operator is not constrained in any way to answer the questions in order, nor, without some extra coding, to answer them only the once.

[lee123]

thanks you guys for all your help i'll try what you said and hopfully it works if not i'll write back thanks,

lee123