I am going to be building a new database application. It is currently on Excel sheets, there can be upwards of 100 questions on a spreadsheet. On the Access side, I have a database app that was built several years ago which I would like to use as a shell. It has a number of tabs so when you click that tab, the form displays questions pertaining to that tab. My question is on a tab, is there a limit screen real-estate wise.
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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Is there a limit to the tabbed control on a screen...I have a lot of fields i need to add 1
- Thread starter Pack10
- Start date
Yes. the limit is the size of the detail section (minus any border, minus the tabs themselves). You can make it as large as will fit!
The speculative judgment of the quality of an answer is based directly on … what was the question again?
The speculative judgment of the quality of an answer is based directly on … what was the question again?
-
1
- #3
If you are creating a database survey application, I suggest you consider reviewing At Your Survey. This demo database shows how to normalize your table structure. IMO, 100 questions should be 100 records, not 100 fields.
Duane
Hook'D on Access
MS Access MVP
Duane
Hook'D on Access
MS Access MVP
I concur with Duane, and would look at that link. Building a normalized survey database is very challenging especially if you have never seen an example. Most people do it wrong, which may make it easy to enter information and build forms, but makes it near impossible to use the results.
- Thread starter
- #5
I am examining Duane's Survey application. It's great and the design is exactly what I need.
I am trying to figure how to work in the products that my company sells that the users will be asked about.
I may come back at a later time. But for now, this is great.
I am trying to figure how to work in the products that my company sells that the users will be asked about.
I may come back at a later time. But for now, this is great.
- Thread starter
- #6
Duane...
I have analyzed your Survey app and it's great. That is a wonderful design. The questions they have here require a more wordy reply
not a drop down or a radio button but the excel sheet I am using as a guide would almost have a memo field for each question and there could be 50
or more fields. That sounds like trouble. What would be the limit on Memo field usage. Thanks
I have analyzed your Survey app and it's great. That is a wonderful design. The questions they have here require a more wordy reply
not a drop down or a radio button but the excel sheet I am using as a guide would almost have a memo field for each question and there could be 50
or more fields. That sounds like trouble. What would be the limit on Memo field usage. Thanks
Thanks Pack10. Your answer field could be a memo field to allow for more than 255 characters. I'm not sure why you would need "50 or more fields".
Duane
Hook'D on Access
MS Access MVP
Duane
Hook'D on Access
MS Access MVP
- Thread starter
- #8
Using your design Duane (which again is superb)... in my case, one of the parts of the questionaire/survey, the user selects products in a combobox and they get written to a table (wich the survery ID, and the responder information along with the country. So for example the guy from Germany selects 8 products from the combobox. Now in one of the sections of the questionaire there are a series of questions about those products selected..."Low","High" , Yes,No, or a percentage that they would enter. Problem is for each question in this group, I need to show the product list and the place to enter the response.
Is the product being sold in a high risk location? Product 1 Y N
Product 2 Y N
Product 3 Y N
Is the product being sold to a high risk customer? Product 1 Y N
Product 2 Y N
Product 3 Y N
...
So how would one display the products that were selected....i do have them in a table. It's repeatable ...
This orginally came from an Excel sheet where the products were set up in columns across the sheet.
Is the product being sold in a high risk location? Product 1 Y N
Product 2 Y N
Product 3 Y N
Is the product being sold to a high risk customer? Product 1 Y N
Product 2 Y N
Product 3 Y N
...
So how would one display the products that were selected....i do have them in a table. It's repeatable ...
This orginally came from an Excel sheet where the products were set up in columns across the sheet.
I think you would need to do some customization to add new records to the survey results table. This is especially true if the "8 products" could be many more.
The At Your Survey isn't meant to provide a complete solution for every survey. There are a lot of features I didn't add just to keep it simple.
Duane
Hook'D on Access
MS Access MVP
The At Your Survey isn't meant to provide a complete solution for every survey. There are a lot of features I didn't add just to keep it simple.
Duane
Hook'D on Access
MS Access MVP
- Thread starter
- #10
- Thread starter
- #11
I have no idea how to get the items (Products) they select from the combobox into the continuous form.
For example I would have questions 20-60 related to the products selected. But each question is reporting on
each of the products selected. Seems more suited for excel.
For example I would have questions 20-60 related to the products selected. But each question is reporting on
each of the products selected. Seems more suited for excel.
Use Excel. I don't have the time at the moment to provide a more complete database solution for you.
Duane
Hook'D on Access
MS Access MVP
Duane
Hook'D on Access
MS Access MVP
- Status
Similar threads
