Technical Designs
tdd-inc at shaw.ca
Fri Dec 31 11:16:39 CST 2004
I am no expert on this, but my thinking would be... MainForm: MFID | HouseAddress... ect SubForm: which gets created every time... insert your 73 questions into subtable from a basetable SubID | MFID | Question | Answer | Comment | Required Y/N | EditQuestion Y/N Your 73 questions will be EditQuestion = False And Required = True SubForm looks like.. 1 | 1 | Floor type Kitchen | Hard Wood | minor damage | Y | N 2 | 1 | Floor type Livingroom | Carpet | Shag | Y | N ... 74 | 1 | Would I buy this house | Yes | none | N | Y you can base the 'Answer' dropdown selection if you format your questions uniformly. Example - "mat Floor Type" could select all materials from dropdown table. You can even take the first 4 letters and make them disappear You could page through the subform You can have buttons to add new records, go back to the last record you were at or where answer = Null Maybe I'm way off here, and I'm not very good at explaining things sometimes I would appreciate some constructive feedback as I am learning Thanks Happy New Year Phil -----Original Message----- From: Roz Clarke [mailto:roz.clarke at donnslaw.co.uk] Sent: Thursday, December 30, 2004 7:27 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Creating controls on a form table data based I presume you will hold the definitions for each control in a couple of tables (one for controls one for drop-downs with answer choices?) We have a system here which allows user-defined fields in a similar way. The 'controls' table looks a bit like this: Detail ID | Label | Type (Number, Text, Flag, Value) | Mandatory Y/N And for those which are type Text you can add rows to a second table to create combos: Detail ID (FK) | Code | Description I didn't design it, but even so it works OK! :P How about tabs instead of new forms? Then your users can assign each new control to a tab and keep control without you having to build new code on the fly. Good luck! Roz -----Original Message----- From: Erwin Craps - IT Helps [mailto:Erwin.Craps at ithelps.be] Sent: 30 December 2004 14:47 To: Access Developers discussion and problem solving Subject: RE: [AccessD] Creating controls on a form table data based I have 73 question with in total 372 posible choices/answers. And its a dynamic thing, so questions will be added by the user, and the forms need to adapt. Showing a popup per question is not an option because this needs user interaction (73 times) and slows down te data entry. So I dont see any other solution then generating unbound forms on the spot and add controls (questions, answers, formatting and code) to them. Each form will have its maximum height depending on the number of questions/answers, so probably i will end up with 10 forms or so. I already noticed that I can not generate a report for this in Access due to the limit in detailsection height, don't know if creating sections can help in this. So I supose I will need to generate the printed report in Word from Access, which is fine for the customer. Hehe, tuff nut to crack... Erwin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson, Karen Sent: Thursday, December 30, 2004 12:35 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Creating controls on a form table data based We just did a similar application, I thought that conditional formatting would be my ticket, but alas, it is not powerful enough to change the visibility of controls on a continuous form. So, what we did was create one form for each question. Each question has different fields for the answer - some are yes no, some need comments, etc. So, we had about 15 questions. I had one form with 15 forms plopped on the one form. Looks like a continuous form to the user but it is lots of forms all tied by the unique identifier. We used one table for the questions and answers, on the form we just display those relevant to each question. Pain in ze butt butt it worked. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Erwin Craps - IT Helps Sent: Thursday, December 30, 2004 6:10 AM To: accessd at databaseadvisors.com Subject: [AccessD] Creating controls on a form table data based Yes it is an AccessD, my mistake. No, not one question at the time. That's just the point. I first proposed that, but after discussing this with the customer, we decided that this goes way to slow for data entry at location with a tablet pc in the hand walking around. Erwin -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Thursday, December 30, 2004 11:46 AM To: dba-tech at databaseadvisors.com Subject: Re: [dba-Tech] Creating controls on a form table data based Hi Erwin First, isn't this an AccessD topic? Then, couldn't you use a continuous form where you display one question at a time? If so, you could define the type of question (yes/no, amount, etc.), the question itself etc. dynamically. /gustav >>> Erwin.Craps at ithelps.be 30-12-2004 11:16:26 >>> Hi I developing an app for a tablet pc, that will be uses by an expert to estimate real estates. The target is that the expert gets out his tablet pc in the building and starts clicking predifined answers to descibe the estate. Additional comments per answer must be posible (example wooden floor = yes, comment= slightly damaged) For reasons of speed and overview the several questions and respective answers need to be on a minimum of forms to avoid form switching They now use a paper form. The difficulty lies in the fact that questions and there choices/answers can vary over time. So the only solution to achieve this looks like creating forms and their controls programaticaly on the spot. So I got in to creating x number of controls on x number of forms, but I'm tumbling in to problems like a limited form length, how to entry code (programaticaly) after a control, etc etc. The answers are not straigtforward yes/no but can be any of these Yes/No (boolean) amount (Euro) number simple text long text (memo) multiple choice (option group) 1 choice only multiple choice (option group) multiple choices So I'm getting scared not beeing on the right track here, or not posible in a reasonable time. Some great webpage on this material would help me with some guidelines how to achive this. Thanks Erwin Craps Zaakvoerder www.ithelps.be/onsgezin _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com