By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,390 Members | 2,050 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,390 IT Pros & Developers. It's quick & easy.

Continuous form issue

P: n/a
DFS
I'm sure this has been discussed before, but I'm too tired to hunt for it.

I have a survey table containing questions with different answer scales.
Some are 1 to 5, others are A,B,C, etc. I show these answer scales in a
listbox.

When the scale type changes, the list items should change. Problem is, the
bound continuous form shows for all questions only the scale for the first
question - unless I click on a question with a different scale, then all
questions change to show that scale. This behavior applies whether the
listbox is bound or not, of course.

I have some ideas about how to brute force it, but it will be more work than
I want to do. The bound continuous form is perfect - except for this
glaring flaw.

Using Access97 - because I need to distribute a run-time and don't want to
buy yet another Access tool.

Any ideas or solutions?

Thanks
Nov 13 '05 #1
Share this Question
Share on Google+
10 Replies


P: n/a
Hi DFS,
I have the same (continuous form with questions)
No problem here ... but I use a bound combobox for the answers.
When I change this to listbox I get the same behavior as you describe.
Too tired to sort this out now ;-)
Maybe you can try the combobox-approach also.

--
Hope this helps
Arno R

"DFS" <no****@DFS.com> schreef in bericht news:5k****************@fe03.lga...
I'm sure this has been discussed before, but I'm too tired to hunt for it.

I have a survey table containing questions with different answer scales.
Some are 1 to 5, others are A,B,C, etc. I show these answer scales in a
listbox.

When the scale type changes, the list items should change. Problem is, the
bound continuous form shows for all questions only the scale for the first
question - unless I click on a question with a different scale, then all
questions change to show that scale. This behavior applies whether the
listbox is bound or not, of course.

I have some ideas about how to brute force it, but it will be more work than
I want to do. The bound continuous form is perfect - except for this
glaring flaw.

Using Access97 - because I need to distribute a run-time and don't want to
buy yet another Access tool.

Any ideas or solutions?

Thanks

Nov 13 '05 #2

P: n/a
On Tue, 8 Mar 2005 01:00:09 -0500, "DFS" <no****@DFS.com> wrote:
I'm sure this has been discussed before, but I'm too tired to hunt for it.

I have a survey table containing questions with different answer scales.
Some are 1 to 5, others are A,B,C, etc. I show these answer scales in a
listbox.

When the scale type changes, the list items should change. Problem is, the
bound continuous form shows for all questions only the scale for the first
question - unless I click on a question with a different scale, then all
questions change to show that scale. This behavior applies whether the
listbox is bound or not, of course.

I have some ideas about how to brute force it, but it will be more work than
I want to do. The bound continuous form is perfect - except for this
glaring flaw.

Using Access97 - because I need to distribute a run-time and don't want to
buy yet another Access tool.

Any ideas or solutions?

Thanks


You pretty much have to use an outer join to get the option text, bind a text
box to that, and stack it on top of your combo box with just the drop-down
button sticking out. When the Combo box gets the focus, it moves in front of
the text box, but only for that row.

There are more steps than that, of course, you have to make the text box
locked and disabled, and for mouse clicks, you have to place a transparent
button on top of the text box to trap On Enter envents, and set the focus to
the combo box.
Nov 13 '05 #3

P: n/a
DFS
Arno R wrote:
Hi DFS,
I have the same (continuous form with questions)
No problem here ... but I use a bound combobox for the answers.
When I change this to listbox I get the same behavior as you describe.
Too tired to sort this out now ;-)
Maybe you can try the combobox-approach also.
I've tried the combobox in the past and it works somewhat better, as you
can't see the available answers until the combobox is dropped down, at which
point the list is requeried and shows the correct answer scale.

But in this system I want the user to always see all available answers for
each question.

Thanks


"DFS" <no****@DFS.com> schreef in bericht
news:5k****************@fe03.lga...
I'm sure this has been discussed before, but I'm too tired to hunt
for it.

I have a survey table containing questions with different answer
scales. Some are 1 to 5, others are A,B,C, etc. I show these answer
scales in a listbox.

When the scale type changes, the list items should change. Problem
is, the bound continuous form shows for all questions only the scale
for the first question - unless I click on a question with a
different scale, then all questions change to show that scale. This
behavior applies whether the listbox is bound or not, of course.

I have some ideas about how to brute force it, but it will be more
work than I want to do. The bound continuous form is perfect -
except for this glaring flaw.

Using Access97 - because I need to distribute a run-time and don't
want to buy yet another Access tool.

Any ideas or solutions?

Thanks

Nov 13 '05 #4

P: n/a
DFS
Steve Jorgensen wrote:
On Tue, 8 Mar 2005 01:00:09 -0500, "DFS" <no****@DFS.com> wrote:
I'm sure this has been discussed before, but I'm too tired to hunt
for it.

I have a survey table containing questions with different answer
scales. Some are 1 to 5, others are A,B,C, etc. I show these answer
scales in a listbox.

When the scale type changes, the list items should change. Problem
is, the bound continuous form shows for all questions only the scale
for the first question - unless I click on a question with a
different scale, then all questions change to show that scale. This
behavior applies whether the listbox is bound or not, of course.

I have some ideas about how to brute force it, but it will be more
work than I want to do. The bound continuous form is perfect -
except for this glaring flaw.

Using Access97 - because I need to distribute a run-time and don't
want to buy yet another Access tool.

Any ideas or solutions?

Thanks


You pretty much have to use an outer join to get the option text,
bind a text box to that, and stack it on top of your combo box with
just the drop-down button sticking out. When the Combo box gets the
focus, it moves in front of the text box, but only for that row.

There are more steps than that, of course, you have to make the text
box locked and disabled, and for mouse clicks, you have to place a
transparent button on top of the text box to trap On Enter envents,
and set the focus to the combo box.


Thanks, but I want to use a listbox that always shows the available answers
that pertain to that type of question. For some the scale is A=very
satisfied, B= satisfied, C=neutral, etc. For others it's 1=very often,
2=often, 3=seldom, 4=never, etc.

With a combobox the user only ever sees the available answers when they drop
the list down, and by then my OnCurrent event has populated the combobox
with the correct list and it works OK. (note: even the combobox has
problems. Say the previously recorded answer is B, but there are two
different scales and B means something different in each. When you load up
a survey, you see only the first meaning of B until you click on a question
using the second scale, which then shows up).

I think I'm going to have to use a method I've tried in the past. Unbound
form, with unbound text and list boxes and code to show the questions,
answer scales, and to capture and show the responses. It's a big kludge,
but is the only way I can think of to overcome this Access continuous form
issue.

Nov 13 '05 #5

P: n/a
But in this system I want the user to always see all available answers for
each question.

Your users *can* see all available answers when they 'arrive at' the specific question (or
answer)
You just need to code Me!Answer.dropdown in the On_Enter event.

--
Hope this helps
Arno R

Nov 13 '05 #6

P: n/a
DFS wrote:
I'm sure this has been discussed before, but I'm too tired to hunt for it.

I have a survey table containing questions with different answer scales.
Some are 1 to 5, others are A,B,C, etc. I show these answer scales in a
listbox.


How about...

Using the footer of the form to display a repeat of the question
selected on the detail section of the form and a list box. Other coding
for format of the detail section could be included ina generic on
current event.

Or how about a subform with the list of questions on it, and, to the
right, on the main form, the list box populated by the selected subform
question?
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #7

P: n/a
DFS
Arno R wrote:
But in this system I want the user to always see all available
answers for each question.
Your users *can* see all available answers when they 'arrive at' the
specific question (or answer)


They need to always see all available answers for every question. Before
they 'arrive' at the question.

You just need to code Me!Answer.dropdown in the On_Enter event.

Nov 13 '05 #8

P: n/a
DFS
Tim Marshall wrote:
DFS wrote:
I'm sure this has been discussed before, but I'm too tired to hunt
for it.

I have a survey table containing questions with different answer
scales. Some are 1 to 5, others are A,B,C, etc. I show these answer
scales in a listbox.


How about...

Using the footer of the form to display a repeat of the question
selected on the detail section of the form and a list box. Other
coding for format of the detail section could be included ina generic
on current event.

Or how about a subform with the list of questions on it, and, to the
right, on the main form, the list box populated by the selected
subform question?


Thanks, but those aren't workable options for me. I want the survey answer
scale and selected answer to be visible at all times. And I want a
different answer scale to be shown depending on the question. And I want to
use a bound continuous form. I think I want too much out of Access.

Take a look at this web page http://free-online-surveys.co.uk/# and choose
the 'Try Our Survey' button and check it out. That's similar to what I
want.

Nov 13 '05 #9

P: n/a
DFS wrote:
Or how about a subform with the list of questions on it, and, to the
right, on the main form, the list box populated by the selected
subform question?
Thanks, but those aren't workable options for me.

Take a look at this web page http://free-online-surveys.co.uk/# and choose
the 'Try Our Survey' button and check it out. That's similar to what I
want.


I'm not sure if you've settled on a design yet, so I'm just tossing out
stuff. 8)

What about a single form view, equivalent to the single page on the
survey I just looked at? The form recordsource could well be one that
divides the survey up into pages and then a subform(s) on the detail
section could deal with the 5 or 6 questions. On current for the main
form would need a lot of procs to determine what is visible/invisible, etc.

Just brainstorming. 8)
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #10

P: n/a
DFS
Tim Marshall wrote:
DFS wrote:
Or how about a subform with the list of questions on it, and, to the
right, on the main form, the list box populated by the selected
subform question?


Thanks, but those aren't workable options for me.

Take a look at this web page http://free-online-surveys.co.uk/# and
choose the 'Try Our Survey' button and check it out. That's similar
to what I want.


I'm not sure if you've settled on a design yet, so I'm just tossing
out stuff. 8)

What about a single form view, equivalent to the single page on the
survey I just looked at? The form recordsource could well be one that
divides the survey up into pages and then a subform(s) on the detail
section could deal with the 5 or 6 questions. On current for the main
form would need a lot of procs to determine what is
visible/invisible, etc.

Just brainstorming. 8)


Thanks for the brainstorming, Tim.

One idea I had early on is a separate page for each different answer scale.
Problem with that is the survey itself has 4 main sections, and the shortest
section (12 questions) has four different answer scales, some with only one
question. So it will look funny to show only one question on a page,
because its answer scale is a little different than the previous and next
questions' answer scales.

What I can definitely make work is an unbound form that shows four or five
questions at a time. text1...text5 are unbound textboxes that show the
question. list1...list5 are unbound listboxes (or I could use frames and
option buttons) that show the answer scale. VBA code would capture and
present the selected items. I would create custom navigation buttons
(versus a native scrollbar with the continuous form) to move through the
survey (130 questions total) four or five questions at a time.

The bound continuous form is so much easier to create and use and maintain
that I would prefer to go with it. But if I can't, I can't

Nov 13 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.