Re: Survey Design

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Wow! It looks like this is it!

I just finished putting the form together per your very detailed
(thank you:)) instructions and it looks like it will work!

I am so shocked that I finally seem to have a working database that I
haven't dared to try it out - I wanted to write you a quick Thank You
before I start playing :)

I'll make an exact copy of te whole DB before I mess around - this
thing is too precious to loose.

Amy, I hope that you know that I appreciate your help, time and
persistence tremendously. You are awesome, you are da bomb!!!

I will report back after I have taken your DB design on a thorough
test drive.

Thanks a million!


On Sat, 14 Apr 2007 10:49:20 -0500, "Amy Blankenship"
<Amy_nospam@xxxxxxxxxxxxxxxxxxxxxx> wrote:


<men@xxxxxxxx> wrote in message
news:rt1v13lmu6oq8llhb7iglvleda6k008mcj@xxxxxxxxxx
I worked on it a couple of more hours last night. The tables and the
form are up and I think I am very close to having it work.

I don't have enough time this A.M. to get very specific but thought I
run by you the general problem I kept running into last night.

I can't get the form to display the questions from tblquestions nor
the possible answers from answertext.

I am trying to have the subfrorm show all 22 questions at once or at
least a few at a time and the possible answers (mutually exlusive
option group, if possible). All the data entry person would need to do
is put checkmarks to the answers as they appear on the completed by
client paperform he/she is needing to enter.

The first thing you'll need to do is build a query that joins tblAnswers
with tblQuestion. If you don't see a join line between QuestionID and
QuestionID, drag the QuestionID from tblQuestion to tblAnswers.
Double-click the join line and change it to "Show all rows from tblQuestion
and only the rows from tblAnswer where the joined fields are equal. Drag
all fields from both tables to the query...any fields you don't want users
to see, such as QuestionID and AnswerID, you can hide on the form. Now run
the query. You should see all of the fields, but AnswerID will be null in
all records. Double-check to make sure that when you look at the record
selector at the bottom of the grid window that you see the * button. This
means that this is a query that you can add records to. You won't actually
be making more rows, but you will be adding records in tblAnswers. If you
don't see that, post back with the SQL from the SQL view of the query and
maybe we can help you sort it.

Now, you should have a form already that is bound to tblClient. Inside it,
you should have a subform for tblAnswerSession. Make the forms bigger so
you have room to add a new subform in your tblAnserSession_Subform. Use the
subform control with the wizard turned on to add a new subform. Select your
query as the data source, and add all the fields. If you use datasheet
view, you'll find it easier to just show the fields you want the user to
see, which are the question text and the answer. Also, you don't have to
worry about the fine details of layout and such, because the datasheet
ignores most of that. Once you close the wizard, you'll want to resize the
new subform so it fills the space you made for it. Make sure to close the
wizard into the option that lets you continue to work on the form.

Now, select the AnswerID field and go to Format>Change to>Combobox (A
combobox will work in datasheet view, whereas I don't think radio buttons
will). Open the properties box for the new combobox. On the format tab,
change the column count to 2, and the column widths to 0;1. On the Data
tab, select Table/Query for the Row Source type and select
tblPossibleAnswers as the row source.

I suspect after you have had more than one Questionaire session, you may
wind up getting more records than you bargained for. If that is the case,
you need to select the yourQuery_subform and set a filter on it. Post to
the forms newsgroup if that turns out to be a problem. You may also find
you need a Requery of the lowest subform when you're creating a new Answer
Session to make sure that the AnswerSessionID populates properly in
tblAnswers.

HTH;

Amy

.

Relevant Pages

  • Re: Survey Design
    ... The first thing you'll need to do is build a query that joins tblAnswers ... QuestionID, drag the QuestionID from tblQuestion to tblAnswers. ... you have room to add a new subform in your tblAnserSession_Subform. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Form Problem
    ... then I created a query from the Question and Answer ... >relationship with the Answer table ContactID = ContactID. ... Be sure to include BOTH instances of QuestionID - ... Use ContactID as the master/child link field of the subform. ...
    (microsoft.public.access.forms)
  • Why is this query unupdateable??
    ... I get NO error messages about this query from Access 2003. ... FROM tblQuestions INNER JOIN tblResponses ON tblQuestions.QuestionID = ... QuestionID in tblResponses. ... QuestionID FK (this is not defined in the Relationships window, ...
    (microsoft.public.access.queries)
  • Re: SQL UPDATE query help please
    ... categoryID = CategoryID ... questionID = QuestionID ... I have a SQL query that worked fine in my project until it came to ... Dim NewQuestion As String = Question.Text ...
    (microsoft.public.dotnet.languages.vb)
  • All my subforms broke when I upsized
    ... All went well but all the forms in the adp file that use a subform are ... The parent form has a textbox with a questionid control source. ... link child and link master fields but I still get the error. ... What could I be doing wrong with the adp file? ...
    (microsoft.public.access.adp.sqlserver)