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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Jeffr0

  1. Jeffr0

    Best Practices for associating an UNBOUND form to a recordset

    Hello, I'd appreciate any hindsight or techniques for some of the housekeeping necessary for keeping an unbounded form in sync with a recordset. I am working on an app to allow data entry of the responses to a particular survey. (the survey and its underlying representation of questions and...
  2. Jeffr0

    Advice creating survey form

    Just a follow-up. I ended up implementing the form as unbounded, and simply doing a bunch of VB coding. I discovered control choices last night, which allowed me to group some of the checkbox clusters and it makes thing a lot less painless. You are right, it is still a good bunch of code...
  3. Jeffr0

    Advice creating survey form

    Sure, here are some details about the survey. This database needs to contain many different surveys, about a dozen a year; each survey is similar in style, but unique in content (the questions asked; the choices to select). They are mailed to respondents, who complete the forms, and then mail /...
  4. Jeffr0

    Advice creating survey form

    Update -- After speaking with the project manager, I think we can build the form like this to simplify things: frmSurvey (Main Form) - cmbRespondent for selecting a Respondent - cmbSurvey for selecting a Respondent's Survey - cmbRespondent and cmbSurvey are cascading, implemented via VB...
  5. Jeffr0

    Advice creating survey form

    Thanks for your suggestions regarding the form binding. I don't completely understand the process, but I will spend some time working through it tonight with a continuous form just to keep things simple, and see if it makes sense. I've attached a sample survey page. The top section is the...
  6. Jeffr0

    Advice creating survey form

    Hi MajP, thanks for your input. Let me address a few things here. I answered my own question for this one. To populate a Text Field with the contents of a specific field in a specific record, I set the Text Field's Control Source to the following expression...
  7. Jeffr0

    Advice creating survey form

    Thanks for the prompt responses! Yes, I have looked extensively at AYS before asking my question! It was instrumental in helping me refine my schema. Good stuff. But I can't find the answer I need for designing my survey form. I need the form to look exactly like the paper survey (well, very...
  8. Jeffr0

    Advice creating survey form

    Hello, First let me thank the folks on this forum. It's been an invaluable resource for me learning Microsoft Access, though until now I've been strictly lurking. I would like to represent a 3-page survey as a form (probably using a Tab Control) in Access 2007. The form should look as close...
See more

Part and Inventory Search

Back
Top