Re: Using mouse to scroll down a combo list

Hi Eric,

"advice on the structure"

you know me too well ;)

actually, this wasn't about structure -- just used the structure example to show you how to automatically create the answer records and eliminate the need for the users to do it ;)


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




efandango wrote:
Crystal,

I appreciate your advice on the structure of a question and answer setup; but I already have all that working just fine. I just wanted to improve the interface/ergonomics aspect of the user experience. In saying that I already have a complete setup working well; there is always somethine one can learn. In time I will look at your structure setup more closely and see if I can use it to improve my working solution. In the meantime; is there a definitive answer as to whether I can have my mousewheel scroll the highlight bar up and down, rather than have the laist itself move up and down (which incidently, it doesn't due to the max 16 items which I can easily accomodate on my form)

regards

Eric

"strive4peace" wrote:

Hi Eric,

rather than making the user choose each question, add the questions for them.

I will assume you have a table where the questions are defined

Questions
- QID, autonumber
- Question, text
etc

and tables with test info and where you record answers

Tests
- TestID, autonumber
- PersonID, long -- FK to identify who is taking the test
- TestDate, date

Answers
- AID, autonumber
- TestID, long -- FK to tests
- QID, long -- FK to Answers

in the Answers table, make a multi-filed unique index on the combination of
TestID
QID
(instructions on how to do this are in Access Basics) -- this is so, if you accidentally append questions twice, you do not end up with duplicates

then, when you make a new record for Tests, on the form AfterUpdate event, append all the questions to the answers table and requery the subform

'~~~~~~~~~
dim strSQL as string
strSQL = "INSERT INTO Answers (TestID, QID) " _
& " SELECT QID, " & me.testid _
& " FROM Questions;"
currentdb.execute strSQL
currentdb.tabledefs.refresh
DoEvents

me.subform_controlname.requery
'~~~~~~~~~~~~~~

hopefully, you can see the logic of this. If not, post back with questions <smile>


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




efandango wrote:
Thanks Crsytal,

I was aware of these features of the combo box. It is mainy this messing around with arrow keys to go up and down the list of entries that has led me to want to do the same woth the mouse wheel. The 16 records per combo are finite; so no need to increase ListRows. I just want the user to be able to not have to leave the mouse/wheel. The combo box appears on every 'page#' of the main records. It's a quiz answer list, and all 16 have to be answered, hence the desire to just have the mouse wheel scroll the 'highlight' bar up and down. (and it would look as neat as it would be to actually use.)

regards

Eric


"strive4peace" wrote:

Hi Eric,

alt-{down arrow} will drop the list
press {down arrow} to move to the next choice
(once you press {down arrow}, you can press {page up} and {page down})
then {tab} to exit the control and move to the next...

"16 records per combo box"

if you have room on the screen, you can make ListRows a higher number

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




efandango wrote:
Arvin,

Thanks for the reply. Yes. everything you said, I understand (already knew). But what I want is some way of having the 'highlight bar' move up and down by just using the mouse wheel and not having to move the mouse. There is a very good reason for this. I have numerous list of 16 records per combo box, and they all eventually have to be picked (it's a qiz thing). and after a while it gets 'tiring' on the eyes moving the mouse around, wheras it would be better if the hightlight bar just moved up or down.

I know this is not the 'standard' way combo boxes are supposed to work, but it suits this application better if I can get the mouse wheel to do the work.




"Arvin Meyer [MVP]" wrote:

Generally, if you drop the combo down and put the mouse pointer over the values, it will show a selection of the one under the pointer, after a short delay. Using the scroll wheel will move the combo's rows, and after less than a half second delay will show that row selected. Once clicked that remains the selection. With your combos showing the entire range of value, you should be able to simply move your mouse without scrolling. You should not have a delay in that case. You still need to click on the value you want. That's the way combo boxes work.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"efandango" <efandango@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:7C55AD86-7847-4E73-89C8-A046105B5BE4@xxxxxxxxxxxxxxxx
Is there any way I can have my mouse wheel scoll up and down the actual
contents of a list on of a combo box.

I don't mean the standard 'scroll the list' where the list just moves up and
down but stays fixed on the initial selection. Instead I want the mouse to
scroll through the different field contents highlighting as it goes until I
find the field record that I want to use. Then just leave the box, making the
last selected (highlighted) field content my chosen record. I have a finite
list of 16 records in each combo box, and at the moment, have the 'List Rows'
property set to 16.


.

Relevant Pages

  • Re: Using mouse to scroll down a combo list
    ... (instructions on how to do this are in Access Basics) ... It is mainy this messing around with arrow keys to go up and down the list of entries that has led me to want to do the same woth the mouse wheel. ... It's a quiz answer list, and all 16 have to be answered, hence the desire to just have the mouse wheel scroll the 'highlight' bar up and down. ... Once clicked that remains the selection. ...
    (microsoft.public.access.forms)
  • Re: Using mouse to scroll down a combo list
    ... is there a definitive answer as to whether I can have my mousewheel scroll ... answer as to whether I can have my mousewheel scroll the highlight bar up and ... (instructions on how to do this are in Access Basics) ... values, it will show a selection of the one under the pointer, after a short ...
    (microsoft.public.access.forms)
  • Re: Using mouse to scroll down a combo list
    ... I did not respond to the 'mousewheel' part of your question because I have no experience with it. ... Mouse Wheel On/Off, by Stephan Lebans ... Access Basics ... is there a definitive answer as to whether I can have my mousewheel scroll the highlight bar up and down, rather than have the laist itself move up and down can it be done with some kind of control code? ...
    (microsoft.public.access.forms)
  • Re: Using mouse to scroll down a combo list
    ... around with arrow keys to go up and down the list of entries that has led me ... to want to do the same woth the mouse wheel. ... values, it will show a selection of the one under the pointer, after a short ... Using the scroll wheel will move the combo's rows, ...
    (microsoft.public.access.forms)
  • Re: Using mouse to scroll down a combo list
    ... (instructions on how to do this are in Access Basics) ... to want to do the same woth the mouse wheel. ... hence the desire to just have the mouse wheel scroll the 'highlight' bar up ... values, it will show a selection of the one under the pointer, after a short ...
    (microsoft.public.access.forms)