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
|
|||
|
|||
Questionnaire
I have tables set up for my questionnaire and responses. I made the
questionnaire into a form and it lists all the questions. When I create a subform and make it in the subform, it doesnt list the questions. It just lists blank fields. What am I doing wrong? |
#2
|
|||
|
|||
Questionnaire
Sounds like you need to link the two forms. Open the properties of the sub-
form from the form and click the ellipses (...) on Link Child fields and enter the fields in each form that are the link. Flipper wrote: I have tables set up for my questionnaire and responses. I made the questionnaire into a form and it lists all the questions. When I create a subform and make it in the subform, it doesnt list the questions. It just lists blank fields. What am I doing wrong? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200604/1 |
#3
|
|||
|
|||
Questionnaire
I did that and they are linked properly.
"jahoobob via AccessMonster.com" wrote: Sounds like you need to link the two forms. Open the properties of the sub- form from the form and click the ellipses (...) on Link Child fields and enter the fields in each form that are the link. Flipper wrote: I have tables set up for my questionnaire and responses. I made the questionnaire into a form and it lists all the questions. When I create a subform and make it in the subform, it doesnt list the questions. It just lists blank fields. What am I doing wrong? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200604/1 |
#4
|
|||
|
|||
Questionnaire
I wonder too how to set up my combo box. It asks for which fields contain
the values I want to include in my combo box. My choices are AnswerKeyID, QuestionsID, and AnswerText. I know I need to put in AnswerText, but do I put both ID's in, or just one, and if so, which one? "Flipper" wrote: I have tables set up for my questionnaire and responses. I made the questionnaire into a form and it lists all the questions. When I create a subform and make it in the subform, it doesnt list the questions. It just lists blank fields. What am I doing wrong? |
#5
|
|||
|
|||
Questionnaire
Your meaning is unclear, particularly "when I create a subform and make it
in the subform". I know you said that your relationships are set up properly, but something isn't working, so more information is needed. A description of the table structure (not every field, just the primary keys, other fields involved in relationships, and a general description of the table's purpose) would help. "Flipper" wrote in message news I have tables set up for my questionnaire and responses. I made the questionnaire into a form and it lists all the questions. When I create a subform and make it in the subform, it doesnt list the questions. It just lists blank fields. What am I doing wrong? |
#6
|
|||
|
|||
Questionnaire
Well, I hope my relationships are set up right...But it could be wrong...
What I mean by subforms is that I have them nested. Basically, I have a main form called Applications. It has tab controls on that main form. Each tab control has a subform on it. One the Subform called Children (which has infor about each kid such as name, dob, gender, ethnic). I then put the Questions form on the children subform. (nested it). But all I get is blank fields when I do. The form on its own, not as a subform works fine. It asks a question and i have a box for the answers. I don't know how to get it in my main form and have it relate to each child. "BruceM" wrote: Your meaning is unclear, particularly "when I create a subform and make it in the subform". I know you said that your relationships are set up properly, but something isn't working, so more information is needed. A description of the table structure (not every field, just the primary keys, other fields involved in relationships, and a general description of the table's purpose) would help. "Flipper" wrote in message news I have tables set up for my questionnaire and responses. I made the questionnaire into a form and it lists all the questions. When I create a subform and make it in the subform, it doesnt list the questions. It just lists blank fields. What am I doing wrong? |
#7
|
|||
|
|||
Questionnaire
Relationships exist between tables, not forms. Nested subforms are fine,
but are not going to create relationships. The relationships come first, at the table level. That's why I asked about your tables, but maybe it's best to back up a step first. What real-world situation is your database intended to address. It sounds as if maybe you want to have an application form, and a subform on which children are listed, and another subform for information about each child. In that case you would have an Application table related one-to-many to a Children table, which is in turn related one-to-many with a Questions table. In terms of forms and subforms, the Questions subform would be nested in the Children form, which in turn is nested in the Application form. Of course, my understanding may be completely inaccurate. In any case, there are a lot of unresolved details in my quick explanation. "Flipper" wrote in message news Well, I hope my relationships are set up right...But it could be wrong... What I mean by subforms is that I have them nested. Basically, I have a main form called Applications. It has tab controls on that main form. Each tab control has a subform on it. One the Subform called Children (which has infor about each kid such as name, dob, gender, ethnic). I then put the Questions form on the children subform. (nested it). But all I get is blank fields when I do. The form on its own, not as a subform works fine. It asks a question and i have a box for the answers. I don't know how to get it in my main form and have it relate to each child. "BruceM" wrote: Your meaning is unclear, particularly "when I create a subform and make it in the subform". I know you said that your relationships are set up properly, but something isn't working, so more information is needed. A description of the table structure (not every field, just the primary keys, other fields involved in relationships, and a general description of the table's purpose) would help. "Flipper" wrote in message news I have tables set up for my questionnaire and responses. I made the questionnaire into a form and it lists all the questions. When I create a subform and make it in the subform, it doesnt list the questions. It just lists blank fields. What am I doing wrong? |
#8
|
|||
|
|||
Questionnaire
Is there any way I can send you my Word document of the form i am basing my
DB on and a copy of my db? "BruceM" wrote: Relationships exist between tables, not forms. Nested subforms are fine, but are not going to create relationships. The relationships come first, at the table level. That's why I asked about your tables, but maybe it's best to back up a step first. What real-world situation is your database intended to address. It sounds as if maybe you want to have an application form, and a subform on which children are listed, and another subform for information about each child. In that case you would have an Application table related one-to-many to a Children table, which is in turn related one-to-many with a Questions table. In terms of forms and subforms, the Questions subform would be nested in the Children form, which in turn is nested in the Application form. Of course, my understanding may be completely inaccurate. In any case, there are a lot of unresolved details in my quick explanation. "Flipper" wrote in message news Well, I hope my relationships are set up right...But it could be wrong... What I mean by subforms is that I have them nested. Basically, I have a main form called Applications. It has tab controls on that main form. Each tab control has a subform on it. One the Subform called Children (which has infor about each kid such as name, dob, gender, ethnic). I then put the Questions form on the children subform. (nested it). But all I get is blank fields when I do. The form on its own, not as a subform works fine. It asks a question and i have a box for the answers. I don't know how to get it in my main form and have it relate to each child. "BruceM" wrote: Your meaning is unclear, particularly "when I create a subform and make it in the subform". I know you said that your relationships are set up properly, but something isn't working, so more information is needed. A description of the table structure (not every field, just the primary keys, other fields involved in relationships, and a general description of the table's purpose) would help. "Flipper" wrote in message news I have tables set up for my questionnaire and responses. I made the questionnaire into a form and it lists all the questions. When I create a subform and make it in the subform, it doesnt list the questions. It just lists blank fields. What am I doing wrong? |
#9
|
|||
|
|||
Questionnaire
Sorry, no. Why don't you start by describing the situation? There is an
application. Who is applying, and for what? Why are children listed on the application? What sorts of questions? If a civic group is submitting applications for children to attend summer camp, you might say something like: "A civic group submits applications for children to attend summer camp. There could be just one child, or as many as twenty. Each child is listed separately. Each child's listing includes Name, DOB and other personal information. A series of questions needs to be answered about each child." In describing the situation, you do not need a lot of detail. "Name, DOB and other personal information" is plenty to describe the Children table. By the way, I need to modify something I said before. The relationship to the Questions table would probably be one-to-one, but to what other table I am not sure. "Flipper" wrote in message ... Is there any way I can send you my Word document of the form i am basing my DB on and a copy of my db? "BruceM" wrote: Relationships exist between tables, not forms. Nested subforms are fine, but are not going to create relationships. The relationships come first, at the table level. That's why I asked about your tables, but maybe it's best to back up a step first. What real-world situation is your database intended to address. It sounds as if maybe you want to have an application form, and a subform on which children are listed, and another subform for information about each child. In that case you would have an Application table related one-to-many to a Children table, which is in turn related one-to-many with a Questions table. In terms of forms and subforms, the Questions subform would be nested in the Children form, which in turn is nested in the Application form. Of course, my understanding may be completely inaccurate. In any case, there are a lot of unresolved details in my quick explanation. "Flipper" wrote in message news Well, I hope my relationships are set up right...But it could be wrong... What I mean by subforms is that I have them nested. Basically, I have a main form called Applications. It has tab controls on that main form. Each tab control has a subform on it. One the Subform called Children (which has infor about each kid such as name, dob, gender, ethnic). I then put the Questions form on the children subform. (nested it). But all I get is blank fields when I do. The form on its own, not as a subform works fine. It asks a question and i have a box for the answers. I don't know how to get it in my main form and have it relate to each child. "BruceM" wrote: Your meaning is unclear, particularly "when I create a subform and make it in the subform". I know you said that your relationships are set up properly, but something isn't working, so more information is needed. A description of the table structure (not every field, just the primary keys, other fields involved in relationships, and a general description of the table's purpose) would help. "Flipper" wrote in message news I have tables set up for my questionnaire and responses. I made the questionnaire into a form and it lists all the questions. When I create a subform and make it in the subform, it doesnt list the questions. It just lists blank fields. What am I doing wrong? |
#10
|
|||
|
|||
Questionnaire
Ok. WE have a program that helps low/moderate income families with
asthma/allergies. the fill out an app and we see if they qualify. The app asks Renter info and homeowner info (name, address, phone) (for each, if applicable). Then, there is a children section for each child. It asks name, dob,sex,race. It asks "your relationship to child", and anme and phone number of legal guardian/parent of child. Then there are a series of questions for that child, with the answer of yes, no, or don't know. (This repeats for each child). then there are 13 questions in another section of the app for the applicant (usualy the parent). Then there are small questions in part 4 that asks income and then for staff use only there are more questions; date app rcvd, date applicant contacted, inspection/assesment?, basic intervention? , custom intvnt? "BruceM" wrote: Sorry, no. Why don't you start by describing the situation? There is an application. Who is applying, and for what? Why are children listed on the application? What sorts of questions? If a civic group is submitting applications for children to attend summer camp, you might say something like: "A civic group submits applications for children to attend summer camp. There could be just one child, or as many as twenty. Each child is listed separately. Each child's listing includes Name, DOB and other personal information. A series of questions needs to be answered about each child." In describing the situation, you do not need a lot of detail. "Name, DOB and other personal information" is plenty to describe the Children table. By the way, I need to modify something I said before. The relationship to the Questions table would probably be one-to-one, but to what other table I am not sure. "Flipper" wrote in message ... Is there any way I can send you my Word document of the form i am basing my DB on and a copy of my db? "BruceM" wrote: Relationships exist between tables, not forms. Nested subforms are fine, but are not going to create relationships. The relationships come first, at the table level. That's why I asked about your tables, but maybe it's best to back up a step first. What real-world situation is your database intended to address. It sounds as if maybe you want to have an application form, and a subform on which children are listed, and another subform for information about each child. In that case you would have an Application table related one-to-many to a Children table, which is in turn related one-to-many with a Questions table. In terms of forms and subforms, the Questions subform would be nested in the Children form, which in turn is nested in the Application form. Of course, my understanding may be completely inaccurate. In any case, there are a lot of unresolved details in my quick explanation. "Flipper" wrote in message news Well, I hope my relationships are set up right...But it could be wrong... What I mean by subforms is that I have them nested. Basically, I have a main form called Applications. It has tab controls on that main form. Each tab control has a subform on it. One the Subform called Children (which has infor about each kid such as name, dob, gender, ethnic). I then put the Questions form on the children subform. (nested it). But all I get is blank fields when I do. The form on its own, not as a subform works fine. It asks a question and i have a box for the answers. I don't know how to get it in my main form and have it relate to each child. "BruceM" wrote: Your meaning is unclear, particularly "when I create a subform and make it in the subform". I know you said that your relationships are set up properly, but something isn't working, so more information is needed. A description of the table structure (not every field, just the primary keys, other fields involved in relationships, and a general description of the table's purpose) would help. "Flipper" wrote in message news I have tables set up for my questionnaire and responses. I made the questionnaire into a form and it lists all the questions. When I create a subform and make it in the subform, it doesnt list the questions. It just lists blank fields. What am I doing wrong? |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Analysis of Questionnaire Data | J. Reeves | New Users | 3 | January 4th, 2006 11:48 PM |
I want to construct a questionnaire using Microsoft Publisher. | jilgu | Publisher | 3 | December 15th, 2005 06:16 PM |
Questionnaire - dilemma. | Anthony Hodges | Using Forms | 6 | March 9th, 2005 06:28 PM |
Questionnaire - dilemma. | Anthony Hodges | Setting Up & Running Reports | 6 | March 9th, 2005 06:28 PM |
Questionnaire form | Jean | New Users | 2 | May 24th, 2004 07:08 AM |