4CheckMarks and 4Options

[SAMI2]

Hi
I need your help to complete this program, I have some modifications.
first check the attch "2Check".

When I choose checkA, optionA selected automatically, I do not want to work with each other,
maybe I choose CheckA and OptionB result would be zero or choose CheckA and OptionA result would be one.

thanks

[missinglinq]

First off, you're going to have to explain what you're trying to do a great deal more clearly than you have if you want anyone to be able to help you! Remember, you know what you're doing, we don't!

Secondly, when attaching a file, please state the version of Access you're using. Downloading and unzipping your file is a total waste of time for those experts here who don't run Access 2007.

Linq ;0)>


Moderator

[SAMI2]

Hi missinglinq
I am sorry about that.
the version MS Access 2007.
------------------------------------------

I have a continues form “Form1” contained 4 checkmarks, 4 options and TextboxResult.

I need code for:
each Checkmark = 0 if I select = 1
Option1 = Checkmark1
Option2 = Checkmark2
Option3 = Checkmark3
Option4 = Checkmark4
Textbox Result =Option1+ Option2+ Option3+ Option3

I need code or any way to get as above information, that form for school tests. and result come to “TextboxResult”

[NeoPa]

I tried to read your second post - and I couldn't make any sense of it. Is there someone there who could help you with a translation?

[SAMI2]

thank you so much for reply.

same Question in other way.

Should be come the correct answer score to the result box.
in Question no. (1)
if choose A should be the result = 0.
if choose B should be the result = 1.
if choose C should be the result = 0.
if choose D should be the result = 0.

How I specify the correct answer.

Maybe you get my idea clearly in this attachment.

I need some modifications in one of files.

thanks

[ChipR]

To use checkboxes in continuous forms, they have to be related to fields in your table. You need to make fields like AIsChecked, BIsChecked, CIsChecked, DIsChecked and you can make them Yes/No fields.
Now, you need to store the actual correct answer in your table!
Then your iif code says IIF(AIsChecked AND fldAns1 = fldCorrectAnswer,1,0)
You might want to use radio buttons rather than the check boxes at some point, but see if that helps.

[NeoPa]

@SAMI2
Unfortunately no.

Like most people, I don't trust attachments from sources I don't know anything about. The idea is to express the question clearly in the thread. Apart from anything else, a download automatically involves a lot more time just to look at the problem. If everybody took that approach then very very much less help could be given by a site like this. It would essentially not work. There are situations where it is necessary to post an attachment, but to explain the problem is not one of them.

This is obviously more difficult for those whose first language is not English (the only language this forum accepts). Perhaps it would be a good idea to write it out clearly in your native language then translate it using Yahoo! Babel Fish - Text Translation and Web Page Translation or similar web site.

I'm sorry. I can't see any better way of proceeding.

[SAMI2]

Hi ChipR

where use this code:
IIF(AIsChecked AND fldAns1 = fldCorrectAnswer,1,0)

please if you make modifications in attached file.