Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Best way to deal with multiple questionnaire types

Posted on 2014-12-19
4
Medium Priority
?
130 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 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 668 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 668 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 40

Assisted Solution

by:PatHartman
PatHartman earned 664 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

571 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