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...
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...
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 /...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.