By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

4CheckMarks and 4Options

P: 14
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.

Attached Files
File Type: zip (16.1 KB, 25 views)
Dec 18 '08 #1
Share this Question
Share on Google+
7 Replies

Expert 2.5K+
P: 3,532
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)>

Dec 19 '08 #2

P: 14
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”
Dec 20 '08 #3

Expert Mod 15k+
P: 31,418
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?
Dec 22 '08 #4

P: 14
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.

Attached Files
File Type: zip Check (19.8 KB, 38 views)
Dec 23 '08 #5

Expert 100+
P: 1,287
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.
Dec 23 '08 #6

Expert Mod 15k+
P: 31,418
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.
Dec 23 '08 #7

P: 14
Hi ChipR

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

please if you make modifications in attached file.
Jan 16 '09 #8

Post your reply

Sign in to post your reply or Sign up for a free account.