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...

Okay to describe my database: Right now I have three tables - 1 for passwords, that isnt linked to anything else 2. one that holds all the info about the participant including who they were interviewed by, gender, height, weight etc as well as all the data for the questionnaires. Before I...

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...