Solved

Best way to deal with multiple questionnaire types

Posted on 2014-12-19
4
125 Views
Last Modified: 2014-12-22
I'm just looking for advice.  I am creating a database for the purpose of an interview process.  Questions and answers.

But depending on the individual filling out the questionnaire different sub-forms need to be presented.  There will be one main form for general questions and answers.  But then depending on the type of application being filled out, different sub-forms need to be opened on the main form.

Is there a way via VBA code to do this or do I need several main forms with their respective sub-forms designed into them?

If different sub-forms can be presented to the user what type of code needs to be included in the main form to make them open?

--Steve
0
Comment
Question by:SteveL13
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 167 total points
ID: 40509103
see this for a starter  http://support.microsoft.com/kb/292299
0
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 167 total points
ID: 40509222
You can modify the SourceObject value of your SubForm control to show a specific Form in your Subform control:

me.YourSubformControl.SourceObject = "Form1"
0
 
LVL 38

Assisted Solution

by:PatHartman
PatHartman earned 166 total points
ID: 40509236
I don't have enough information to define specific tables for you but the following should get you going.
tblQuestionnaireType
QuestionnaireTypeID (autonumber, PK)
Description
...
tblQuestions
QuestionID (autonumber, PK)
QuestionText
...
tblQuestionnaireQuestions
QQID (autonumber, PK)
QuestionSeq (used to order the question on the report or form)
QuestionnaireID (FK to tblQuestionnaire)
QuestionID (FK to tblQuestions
...
tblPerson
PersonID (autonumber, PK)
FirstName
LastName
....
tblPersonAnswers
AnswerID (autonumber, PK)
PersonID
QQID (FK to tblQuestionnaireQuestions)
Answer

This model allows a specific question to be used in multiple questionnaires.  When the questionnaire starts, your app decides what questionnaire will be used and then copies the QQID's from tblQuestionnaireQuestions for the chosen QuestionnaireID and appends them to tblPersonAnswers  with the PersonID of the person answering the questions.

There are lots of other options if you are using multiple choice questions or even a variety but this sounds like text answers so I didn't go into that.
0
 

Author Comment

by:SteveL13
ID: 40512866
All great advice.  Thank you.
0

Featured Post

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question