Search results

Okay this is what I have done. It seems to work but I just want to make sure I have correctly written the code and that it is as "cllean" as possible so that I can cover all eventualities. Basically what happens now is that if a person choosen yes to question 1, questions 2,3, or 4 appear...

haha I konw it was 4 but it I was too tired to try and work it out :)

Well the reason I thonk his reverse engineering wont week is that from what I understand is that he is telling me to populte the option groups based on what I have in the table. However the option groups is how to get the info into the table so I dont see how it would work? or do I have to do...

hahah its nice to hear a compliment sometimes when I usually feel like a leech here :) At least you know I am trying to learn as opposed to looking for someone to write the code for me.

Im not so strong on writing queries. Should I do case statements for that? Wouldnt that require 1 module for each question? or should I be using else if statements?

The reason that I need to do it to the values now is that I need to produce a report that automatically scores the questionnaire for me. In this way the research assistant can print off the results straight away from any participants without having to mark it by hand

There are really three options: 1. THey go to sleep before 12am and wakeup after 12am 2. They go to sleep after 12am and wake up after 12am but before 12pm 3. They go to sleep after 12am and wakeup after 12pm 4. They go to sleep after 12pm and wakeup before 12am if they were a shift worker for...

Hi Uncle Gizmo I dont think this work will approach either. THis is a marking guide for a questionnaire that is almost identical (and the precursor) to this one which should give you an idea of what I am looking to do. http://www.ssc.ca/documents/case_studies/2006/documents/sleep_BQ_e.pdf...

Hi I have two fields one which represents the time participants went to sleep, one when they woke up however I dont have any dates - it refers to what they do usually. Is it possible to minus sleeptime from waketime to determine duration of time in bed without dates? Or do I assign dummy dates...

Sorry here it is.

I dont have a problem with you being involved (you have always been a big help to me!) Im just not sure we are thinking about the same thing. I have attached a pared down version of the database. Look at ClevelandQuestionnaire form to see what I mean. For example question 2, although there...

I cant see the new field at all in the table just inst_name1,2 & 3. Are you sure you created it?

Nope the option grou is the field? hehe we are at cross purposes

Because nothing is displayed on the form? Once the value the participant originally selected in the option group is recoded and placed in the appropriate field in the table that is bound to the form, once you close it and reopen it it looks like the form was never filled out?

Okay Can someone tell me what I am doing wrong? I created a practice database with a table that has two variables 1- ParticipantID, 2 - Name ParticipantID was set as a long interger. I created a form with these two variables, a module with the text above, and in the on form load event I put...

Actually it worked for me (I put the value 1 in the table) when I recreated the option group and selected "keep values for later use" however if I repoen the form it does not hold the chouce that the participant placed in there (because it is unbound)?

Are you able to post your practice version? I dont understand it the option group is unbound how it retains any values?

Actually I was just thinking about it now and if its unbound even if it does as it says it would i.e. backend conversion I wouldnt be able to see the results in the form later? Do you think it would be better to create 2 fields for every question and use the statement to convert 1 to the other...

Okay lets say my form is called cleveland Questionnaire and is bound to a table called participantdetails. I have some option groups that needed to be recoded and the new value dropped into the table that the form is bound to into a variable called Q2Cleveland.. Lets call one of the option...

Okay can you explain again step by step. I tried them on a practice database and it didnt work me. I think I didnt understand something. Can you specify which number to start with?