A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Questionnaire



 
 
Thread Tools Display Modes
  #1  
Old April 12th, 2006, 02:10 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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  
Old April 12th, 2006, 03:19 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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  
Old April 12th, 2006, 03:35 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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  
Old April 12th, 2006, 04:21 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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  
Old April 12th, 2006, 04:40 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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  
Old April 12th, 2006, 05:12 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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  
Old April 12th, 2006, 06:02 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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  
Old April 12th, 2006, 06:13 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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  
Old April 12th, 2006, 07:07 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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  
Old April 12th, 2006, 07:19 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 03:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.