P
pietlinden
I am working on a database template for a drug study database.
The queries are generally fairly similar across databases, but the
reports are exported to a Word table (so comments can be added
later). I have the export part mostly working. What I am trying to
figure out is the best way to allow the user to assign each query to a
"section" in the report, and then a sequence within that section.
the basic structure of the relevant parts of the database are like
this:
tblSection(
SectionName, Text, PK,
SectionSequence, Integer, Unique)
tblQuestion(
QuestionName, Text,
Qsection, SectionName, Text
QuestionSequence, Integer, Unique)
I could use the MultiPik form from ADH 2002 Desktop, but I was
wondering how to deal with the fact that I can have multiple sections.
(The MultiPik would assume one section, since there is no way to
assign sections in the MultiPik form sample.) One way I was thinking
of dealing with it was to Open the table of questions and grab the
questions for each section one section at a time. Then the user could
put those questions in sequence using the MultiPik form, and then I
could save the sequence back to the table and update the records
there.
Does anybody have any suggestions about the best way to do this and
which control(s) to use? The basic idea is to create a GUI so that
the users, who are not terribly computer savvy can just click and drag
on the form to put the sections and questions within them into a
sequence and then click a button to export everything to Word.
A TreeView control looks ideal, because I could show the Report
sections as parent nodes and the questions as child nodes. What I
don't know how to do is reorder them in a way that won't require a
zillion steps.
So far, this has been my plan:
1. Use a combobox to choose a section that a query belongs to.
2. Add the query to the appropriate MultiPik listbox
3. When all the queries are added, allow the user to set the sequence
of queries in the listbox.
4. When the sequencing is complete, Allow the user to click a button
that will run the queries and transfer the results to a Word template
with a predefined table in it.
I have gotten this to work by using a form/subform and sequencing the
queries manually, but I don't like it very much.
Any suggestions on how to improve this plan?
Thanks!
Pieter
The queries are generally fairly similar across databases, but the
reports are exported to a Word table (so comments can be added
later). I have the export part mostly working. What I am trying to
figure out is the best way to allow the user to assign each query to a
"section" in the report, and then a sequence within that section.
the basic structure of the relevant parts of the database are like
this:
tblSection(
SectionName, Text, PK,
SectionSequence, Integer, Unique)
tblQuestion(
QuestionName, Text,
Qsection, SectionName, Text
QuestionSequence, Integer, Unique)
I could use the MultiPik form from ADH 2002 Desktop, but I was
wondering how to deal with the fact that I can have multiple sections.
(The MultiPik would assume one section, since there is no way to
assign sections in the MultiPik form sample.) One way I was thinking
of dealing with it was to Open the table of questions and grab the
questions for each section one section at a time. Then the user could
put those questions in sequence using the MultiPik form, and then I
could save the sequence back to the table and update the records
there.
Does anybody have any suggestions about the best way to do this and
which control(s) to use? The basic idea is to create a GUI so that
the users, who are not terribly computer savvy can just click and drag
on the form to put the sections and questions within them into a
sequence and then click a button to export everything to Word.
A TreeView control looks ideal, because I could show the Report
sections as parent nodes and the questions as child nodes. What I
don't know how to do is reorder them in a way that won't require a
zillion steps.
So far, this has been my plan:
1. Use a combobox to choose a section that a query belongs to.
2. Add the query to the appropriate MultiPik listbox
3. When all the queries are added, allow the user to set the sequence
of queries in the listbox.
4. When the sequencing is complete, Allow the user to click a button
that will run the queries and transfer the results to a Word template
with a predefined table in it.
I have gotten this to work by using a form/subform and sequencing the
queries manually, but I don't like it very much.
Any suggestions on how to improve this plan?
Thanks!
Pieter