Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. huv123

    DLookup and updating query/calculated fields

    Thanks Ill give it a try.
  2. huv123

    DLookup and updating query/calculated fields

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

    Printing Multiple Reports issue

    This problem has been solved. Thanks
  4. huv123

    Table organization

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

    Table organization

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

    Table organization

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

    Table organization

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

    Table organization

    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 :)...
  9. huv123

    Printing Multiple Reports issue

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

    Table organization

    cant strcture = can structure
  11. huv123

    Table organization

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

    Table organization

    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?
  13. huv123

    Table organization

    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?
  14. huv123

    Table organization

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

    Table organization

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

    Table organization

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

    Printing Multiple Reports issue

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

    CheckBox Nightmare Part 2 (referencing thread702-14)

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

    CheckBox Nightmare Part 2 (referencing thread702-14)

    There you go.
  20. huv123

    Table organization

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

Part and Inventory Search

Back
Top