Search results for query: *

Thanks Ill give it a try.

THis is probably a simple question but I cant seem to get everything coordinated. I have a form that collects information about participant's in a study including height, weight etc. I need to automatically calculate BMI once a person has placed the information in to the form so I created a...

This problem has been solved. Thanks

v = left (vques,1) & (value(right(vques,1) +1) his causes a syntax error

Thank you CK. I am trying to decide how important normalization is to this process. I can understand when multiple users are using thousands of records but it is not something I could do by myself. At the end of the day for statistical analysis all of the data would be dumped into one table...

Hi CK - They must have EITHER 2 or NO checks - they cant have 3 checks or one checks for a queation . - which means errors include 0100, 1000, 0010, 0001, 1110,1101,1011,0111 and so on... I cannot control which squares they select on the form and i.e. if they dont have a preference for which...

...7 possible "correct/valid" responses and 8 error responses as follows: L1 L2 R1 R2 Dec Bin Bin Bin Bin Num 8 4 2 1 Condition *** *** *** *** *** ************ 00 0 0 0 0 No Preference 01 0 0 0 1 Error 02 0 0 1 0 Error 03 0 0 1 1...

haha I would be finished 6 weeks ago if I could have done what I want. Instead I have to work within the constraints that I have been given. i have heard of normalization and relational databases, only the entire instruction took place over 3 hours 3 years ago ina data managment course :)...

I KNOW What the problem is now. Just not what to do! I realised the difference between the dummy database and my database is that on the close report event I have the text: Private Sub Report_Close() Forms!frmReportView.Visible = True End Sub I have this so when the research assistant closes...

cant strcture = can structure

That isnt how I have structured the forms. You can take alook - I uploaded it in my first post. I am trying to see how I cant this structure in my existing database without starting again.

Also there are 15 possible combinations of the 4 checkboxes per question - most of which are errors and which I need to trigger a msg bo - how does this relate back to the table answers?

Hi Leslie - but the participant will only ever take Questionnaire 1 once, Questionnaire 2 once, and so on.. doesnt that make the survey table redundant? Also I am trying to link the form/control source to a table which one am I doing it to?

Fneily - I meant that cannot use combo boxes for selection of answers. I have been criticised for not thinking like a programmer - sometimes a programmer will need view the problem through the eyes of a psychologist.

Les Paul Can you go through your answer with me? I am not sure I understand

I emant to s say that there are 6 questionnaires that each participant can only do each questionnaire once. [qoute] The AceMan1 made a point that you never answered - why not just have the users select from the table TheAceMan1 suggested: Strong Left (both boxes checked) Strong Right Medium...

ve have seen a number of threads on this but I cant seem to get my button going. Basically the structure of my forms/database is that there is a switchboard on which there are two buttons, ones to a form called "Data Entry View" each of which has a button for each form that when clicked opens a...

With regards to having 4 checkboxes for each question, in the graphical design I cant change anything about this howeverI was not aware that there was a group function like option groups etc that I could use for check boxes. Do you mean using a before update event that records a value for a...

There you go.

This is from the TheAceMan1 The problem is you have a table with: Q1L1 Q1L2 Q1R1 Q1R2 Q2L1 Q2L2 Q2R1 Q2R2 ' ' ' Q?L1 Q?L2 Q?R1 Q?R2 or dedicated checkboxes for each question! Not a good way to go espcially since each question has the same number of checkboxes. Your getting the error because...