Thread: Unbound/Bound Form Delima
10-19-06, 11:02 #1Registered User
- Join Date
- Oct 2006
Unanswered: Unbound/Bound Form Delima
Good Morning Everyone!
I'm designing a survey database. The survey is mailed to members and returned to us. A member will get more than 1 survey (purpose is to track the quality of health) Once returned we will input the responses from the questions on the survey. The purpose is to determine if the members quality of health improved or not over the time between the 2 surveys.
Each response has a numerical value to it. Each response varies...some Y/N, some T/F, etc.
tRAND (primary table) holds: "for each question/response there is a new record"
SurveyDate (short date)
tQuestions table holds:
ctRAND_Response (crosstab query)
TRANSFORM Sum(t_RAND_Responses.Response) AS SumOfResponse SELECT t_RAND_Responses.pkQuestionID AS [Question#], t_RAND_Responses.pkDemoID AS ID, Sum(t_RAND_Responses.Response) AS Evaluation FROM t_Questions INNER JOIN t_RAND_Responses ON t_Questions.pkQuestionID = t_RAND_Responses.pkQuestionID GROUP BY t_RAND_Responses.pkQuestionID, t_RAND_Responses.pkDemoID PIVOT Format([SurveyDate],"Short Date");
My problem is:
I have the input form for the survey which has ALL the questions and a combo box for each answer. Currently this form is UNBOUND because I don't know the BEST method to get the data to the tRAND. Keeping in mind that each question/answer will create a new record, my thought was to use an "Update to table" method. It would also have to include the SurveyDate. I just don't think that's the best approach and was hoping someone with far more vba skills than myself would point me in the right direction.
Thanks for any suggestions
10-19-06, 16:20 #2Grand Poobah
- Join Date
- Sep 2003
Are you looking for a batch implementation? Say: have a form with the overall attributes (survey date, etc ...) on top and a subform that continuous with a combo bound to the questions, a combobo for yes/no (or T/F), and a textbox for responses. On the main form have a button for processing ...Back to Access ... ADO is not the way to go for speed ...