If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Analysis of Questionnaire Data
(I'm using Access2003 (2000 file format).
I've written a questionnaire (using Word) and now want to enter and analyse the responses. I started off by constructing a single table with an associated form but ran into problems as the questionnaire consists of 12 pages with up to 3 multi-part questions on each page. Maximum size of form is about 3 questions. OK, construct multiple forms i.e. form1 = questions 1 to 3, form2 = q4 to 6, etc. but still use a single table. Then ran into problem with maximum table size = 255 records. OK, break the single table into multiple tables (each with its associated form) which reflect the questions on each page of the questionnaire. My question is: How do I link each of the forms (and tables) so that I can work down each form (page) and then step to the next form (page)? (The Access file is 76MB without any data being entered(!) but that is probably due to the size of the forms. The Word document is only 224KB) |
#2
|
|||
|
|||
Analysis of Questionnaire Data
Go to the following page and scroll down to Duane Hookom's list. I believe
that the At Your Survey 2000 file is a very good example of what you need. http://www.rogersaccesslibrary.com/OtherLibraries.asp -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "J. Reeves" wrote: (I'm using Access2003 (2000 file format). I've written a questionnaire (using Word) and now want to enter and analyse the responses. I started off by constructing a single table with an associated form but ran into problems as the questionnaire consists of 12 pages with up to 3 multi-part questions on each page. Maximum size of form is about 3 questions. OK, construct multiple forms i.e. form1 = questions 1 to 3, form2 = q4 to 6, etc. but still use a single table. Then ran into problem with maximum table size = 255 records. OK, break the single table into multiple tables (each with its associated form) which reflect the questions on each page of the questionnaire. My question is: How do I link each of the forms (and tables) so that I can work down each form (page) and then step to the next form (page)? (The Access file is 76MB without any data being entered(!) but that is probably due to the size of the forms. The Word document is only 224KB) |
#3
|
|||
|
|||
Analysis of Questionnaire Data
Thanks Jerry. I'd just found Duane Hookom's list and downloaded it. I haven't
had a chance to do more than glance at it yet but it looks as if it will go a long way towards solving my problem. However, I'd still like to know how to link multiple forms together. Regards, John "Jerry Whittle" wrote: Go to the following page and scroll down to Duane Hookom's list. I believe that the At Your Survey 2000 file is a very good example of what you need. http://www.rogersaccesslibrary.com/OtherLibraries.asp -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "J. Reeves" wrote: (I'm using Access2003 (2000 file format). I've written a questionnaire (using Word) and now want to enter and analyse the responses. I started off by constructing a single table with an associated form but ran into problems as the questionnaire consists of 12 pages with up to 3 multi-part questions on each page. Maximum size of form is about 3 questions. OK, construct multiple forms i.e. form1 = questions 1 to 3, form2 = q4 to 6, etc. but still use a single table. Then ran into problem with maximum table size = 255 records. OK, break the single table into multiple tables (each with its associated form) which reflect the questions on each page of the questionnaire. My question is: How do I link each of the forms (and tables) so that I can work down each form (page) and then step to the next form (page)? (The Access file is 76MB without any data being entered(!) but that is probably due to the size of the forms. The Word document is only 224KB) |
#4
|
|||
|
|||
Analysis of Questionnaire Data
Jerry,
I've found the the "Command Button tool" in the Forms Toolbox. This along with Duane Hookom's example solves all my problems, at least all the ones I'm aware of at present. It's a pity the Command Button tool didn't show up in any of the searches that I made, but that is probably due to me not phrasing my question correctly. Thanks for the prompt response. Regards, John "Jerry Whittle" wrote: Go to the following page and scroll down to Duane Hookom's list. I believe that the At Your Survey 2000 file is a very good example of what you need. http://www.rogersaccesslibrary.com/OtherLibraries.asp -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "J. Reeves" wrote: (I'm using Access2003 (2000 file format). I've written a questionnaire (using Word) and now want to enter and analyse the responses. I started off by constructing a single table with an associated form but ran into problems as the questionnaire consists of 12 pages with up to 3 multi-part questions on each page. Maximum size of form is about 3 questions. OK, construct multiple forms i.e. form1 = questions 1 to 3, form2 = q4 to 6, etc. but still use a single table. Then ran into problem with maximum table size = 255 records. OK, break the single table into multiple tables (each with its associated form) which reflect the questions on each page of the questionnaire. My question is: How do I link each of the forms (and tables) so that I can work down each form (page) and then step to the next form (page)? (The Access file is 76MB without any data being entered(!) but that is probably due to the size of the forms. The Word document is only 224KB) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
cross office program data sharing | m_jurrens | General Discussion | 0 | December 16th, 2005 03:36 PM |
Query does not order the same data in the same way | Milković Aleksandar | Running & Setting Up Queries | 10 | December 15th, 2005 12:01 PM |
Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |