Solved

Best way to deal with multiple questionnaire types

Posted on 2014-12-19
4
121 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
4 Comments
 
LVL 119

Assisted Solution

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

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 34

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

895 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now