Search results

All 4 can never be ticked - at most you can only have two ticked - the two on the left side, the two on the right side or one on each side.

Yay it worked :) Because Im such a relatively newbie I generally google the term i.e. generate text field query and see how other people are approaching similar problems. In this case I saw people doing iif statements, case statements etc. I know how to write the code but not always how to...

Okay I have a report (rptHorneOstbergQuestionnaire) that is based on a query (qryrptHorneOstbergQuestionnaire). In the report I have a total (HOTotal) which is the result of an expression created in the qry. Based on this result I would like to generate text in a text field (HOType) that is...

Thank you Uncle Gizmo I was thinking of doing something this.

Im stumped. I have to create a form based on a questionnaire. I have to recreate the questionnaire exactly and cannot change anything. One of the questions has 6 possible answers - however in order to score the questionnaire two of the possible answers are given the same value of 1. Dont...

Yep, sure :) It can wait. Im off to see fresh air and sunlight anyway before I lose my mind. Have a good day.

Are you able to help me on the otherthread organizing the else ifs and elseifs?

How does a close button that has the command to docmd.close form any different from closing the form?

Nope same thread but he didnt seem to answer my question regarding what to do on close form, just to use queries rather than invisible text field to produce text. When I meant "there is a thread here" in the post above I meant the threat that Brian was helping me with.

Haha I wish I was at work. Its Sunday in Australia and I dont get paid enough as a PhD student to warrant it. I was supposed to be at the Australian Open (Tennis) today instead I am at my computer. Okay there is a thread here regarding check-boxes. Basically each question has 4 checkboxes...

Okay I will do that and see what I can come up with :) Thanks.

HAHAH DO you know how many days I have been working on this? HAHAH That's funny. I looked so carefully too to make sure there were no errors. Its a trick of the mind when you see what you expect to see irregardless of if it is there or not. OkayI will post the final code so that if someone...

This all started because I used to have a combo box form which would just filter the records to the participantID that they selected but one of the research assistants is as dumb as rocks and could not remember to do that before he started to try and enter data. You have to protect for...

Here is the file

Hi Adam while you were replying I changed my response there is some more info there :)

Sorry to be stupid However where it says "TheTableName" "ParticipantIDField" and "IDControlName" do I change this to fit my situation i.e. replace the text THeTableName with tblParticipantData, "ParticipantIDField" with "ParticipantID" (since this is the name of the field in the...

The text box will be invisible to the user? Its for me later when I run a query for a report. The code has to be attached to the After update event because for example after the user clicks on the L1 box access has to decide whether to make R1 and R2 locked or not. I could put the command...

Here I have uploaded a file that recreates the form. I have only included the first bit that works As you can see there are two boxes each in each column I want the person to tick either oine boc in each column, two boces in one column, or no boxes. The code I have written will be...

Tha's the only bit that works ;)

I have to do the three tests (each of which will return a different answer to Q1Answer field) however only one of the conditions can be true. The three tests ask: If the last box (in this case I can just ticked - L1) and L1 are both positive (-1) then I return the value Strong Left If the...