T
Tom
Experts,
I need to advice as to how I can best accomplish a process (from SURVEY_FORM
to POPUP_FORM to TEMP_TABLE to PERMANENT_TABLE).
I apologize for this long-drawn post in advance. However, I think it's
necessary to provide sufficient details in order to eliminate follow-up
questions as much as possible.
BEGIN OF BACKGROUND INFO
==========================
Lookup Table:
- contains 3 fields; "Question ID", "Key Performance Indicator ID (KPIs)"
and "Question"
- there are 16 KPIs and each of them have multiple questions (altogether
there are 100+ questions)
PERMANENT_TABLE:
- contains fields: "Survey Participant", "Question ID", "Answer/Score"
- btw, the field names are a bit different in my apps. I just called them
something more meaningful in this post
SURVEY_FORM:
- contains 16 tabs (one for each KPI)
- on each tab, I use an unbound DLookup field to pull the "Question ID" and
the "Question"
- next to each question, I have a combo box from which the answer will be
selected
Survey Form Process:
- user logs into survey (how is not really important)
- user answers all 100+ questions on each tab
- once the last question has been answered, user will press SUBMIT and their
login info plus the answers are inserted into PERMANENT_TABLE
END OF BACKGROUND INFO
========================
WHAT I WANT TO DO:
==================
- have the ability to provide a "comment" to each question (rather than just
selecting "1", "2", "3", etc.)
INITIAL THOUGHT:
================
- add a command button next to each question
- also add a textbox next to each command button
- via clicking the command button, call an "InputBox"; enter some text,
click OK and transfer the text from the InputBox into the appropriate
textbox on the mainform
PROBLEMS WITH INITIAL THOUGHT:
==============================
- limited by max. number of controls (770 per form)... and I'd go beyond
that by adding those 200 controls (100 sets of command button plus comment
textbox)
- no flexibility on InputBox (e.g. I can't add combos to InputBox)
ENVISIONED PROCESS:
===================
- on each of the 16 tabs on mainform, I have a single command button
- click on the command button and a form will pop up
- depending on which tab (main form) I was on, the popup form will list (in
datasheet view) on those questions that are part of the currently selected
tab or KPIs
- the datasheet view on popup form will allow me to enter a comment next to
each question
- when closing (or hiding) the popup form, comments for each KPI are stored
in some TEMP_TABLE
- then user repeats this process for the next KPI
- the TEMP_TABLE will hold comments for all 100+ questions per each survey
participant
- AND NOW, once the user has provided answers (main form) and comments (via
popup) and clicked SUBMIT, the comments of the 100+ answers must be
transferred from the TEMP_TABLE to PERMANENT_TABLE (the one which stores
user's login info plus his/her combobox answers)
MY QUESTIONS:
==============
- When "calling" the popform, how can I only show those questions that are
part of the current KPI (in the datasheet subform)?
- How can I temporarily store all comments for all questions of all KPIs
once popup is closed or hidden?
- How can I transfer the comments from TEMP_TABLE to PERMAMENT_TABLE and
make the proper link to the
correct survey participant once SUBMIT has been pressed on main form?
- How can I make sure that -- if 2 individuals take survey at same time --
answers won't be mixed up amongst the 2 users?
I appreciate any pointers that provide me info as to how I can best
accomplish this. If anyone knows of a sample db (covering a similar
process), I'd truly appreciate your providing me the URL to the sample db.
Thanks so much!
Tom
I need to advice as to how I can best accomplish a process (from SURVEY_FORM
to POPUP_FORM to TEMP_TABLE to PERMANENT_TABLE).
I apologize for this long-drawn post in advance. However, I think it's
necessary to provide sufficient details in order to eliminate follow-up
questions as much as possible.
BEGIN OF BACKGROUND INFO
==========================
Lookup Table:
- contains 3 fields; "Question ID", "Key Performance Indicator ID (KPIs)"
and "Question"
- there are 16 KPIs and each of them have multiple questions (altogether
there are 100+ questions)
PERMANENT_TABLE:
- contains fields: "Survey Participant", "Question ID", "Answer/Score"
- btw, the field names are a bit different in my apps. I just called them
something more meaningful in this post
SURVEY_FORM:
- contains 16 tabs (one for each KPI)
- on each tab, I use an unbound DLookup field to pull the "Question ID" and
the "Question"
- next to each question, I have a combo box from which the answer will be
selected
Survey Form Process:
- user logs into survey (how is not really important)
- user answers all 100+ questions on each tab
- once the last question has been answered, user will press SUBMIT and their
login info plus the answers are inserted into PERMANENT_TABLE
END OF BACKGROUND INFO
========================
WHAT I WANT TO DO:
==================
- have the ability to provide a "comment" to each question (rather than just
selecting "1", "2", "3", etc.)
INITIAL THOUGHT:
================
- add a command button next to each question
- also add a textbox next to each command button
- via clicking the command button, call an "InputBox"; enter some text,
click OK and transfer the text from the InputBox into the appropriate
textbox on the mainform
PROBLEMS WITH INITIAL THOUGHT:
==============================
- limited by max. number of controls (770 per form)... and I'd go beyond
that by adding those 200 controls (100 sets of command button plus comment
textbox)
- no flexibility on InputBox (e.g. I can't add combos to InputBox)
ENVISIONED PROCESS:
===================
- on each of the 16 tabs on mainform, I have a single command button
- click on the command button and a form will pop up
- depending on which tab (main form) I was on, the popup form will list (in
datasheet view) on those questions that are part of the currently selected
tab or KPIs
- the datasheet view on popup form will allow me to enter a comment next to
each question
- when closing (or hiding) the popup form, comments for each KPI are stored
in some TEMP_TABLE
- then user repeats this process for the next KPI
- the TEMP_TABLE will hold comments for all 100+ questions per each survey
participant
- AND NOW, once the user has provided answers (main form) and comments (via
popup) and clicked SUBMIT, the comments of the 100+ answers must be
transferred from the TEMP_TABLE to PERMANENT_TABLE (the one which stores
user's login info plus his/her combobox answers)
MY QUESTIONS:
==============
- When "calling" the popform, how can I only show those questions that are
part of the current KPI (in the datasheet subform)?
- How can I temporarily store all comments for all questions of all KPIs
once popup is closed or hidden?
- How can I transfer the comments from TEMP_TABLE to PERMAMENT_TABLE and
make the proper link to the
correct survey participant once SUBMIT has been pressed on main form?
- How can I make sure that -- if 2 individuals take survey at same time --
answers won't be mixed up amongst the 2 users?
I appreciate any pointers that provide me info as to how I can best
accomplish this. If anyone knows of a sample db (covering a similar
process), I'd truly appreciate your providing me the URL to the sample db.
Thanks so much!
Tom