Search results

  1. W

    How do I auto populate columns based on a single value input on a form?

    Hi Trevor thanks again, I've attached the file (minus the images to reduce size) I hope it makes sense; there are 4 questionnaire versions each with 8 choices to make and 8 choice variations per choice. The form record source is based on the table via properties rather than code but no object...
  2. W

    How do I auto populate columns based on a single value input on a form?

    Ok that's all working great thank you; how do I make these values into column entries in the table rather than text box names? ie in the after update do I replace textBoxName with a columnname from my table? I have tried it thus: Private Sub Combo767_AfterUpdate() Me."Choice 2 Option Code"...
  3. W

    How do I auto populate columns based on a single value input on a form?

    Hiya follks I hope you can help me again! I need my form to help input thousands of hand filled-in paper forms, of these forms there were many different choice versions and the respondents gave their answer based on that choice, they had 8 choices per form. My table is set up so that the...
  4. W

    How might I auto populate a text box or label?

    Many thanks indeed, this has been a great help! For the times when multiple letters were input in each box I actually made 5 small labels within the one large box so they can all appear at once if needed. Thanks again G
  5. W

    How might I auto populate a text box or label?

    Hi there, I am creating a form to help several users input a 1000’s of paper forms; the people who filled in the forms were asked to order images based on which they liked most and the image identifiers (letters F, J, M, O, & W) were hand written in boxes. My form currently works simply by using...
  6. W

    How do I link two forms to one table?

    Thats Great thanks so much, I'll google adding tabs to an existing form as I keep getting errors like; cant add any more controls to form when I cut and paste.... but this will solve my problem- wish I'd asked you sooner! Thanks again Gray
  7. W

    How do I link two forms to one table?

    Hi folks I hope you can help me- I have never used access (2003) before and am under pressure to help a group of people input data from thousands of questionnaires using access forms (desired over a huge excel spreadsheet to minimise typing errors). The shorter questionnaire booklets have been...
Back
Top Bottom