Mouse Wheel and Combo Boxes

[Mr. T]

All,
I am having a problem and would greatly appreciate any and all
information you could pass on to tme. I am working on a database and I
would like for a person to be able to scroll through a combo box
contents using the mouse wheel.
1st question: Is this Possible?
2nd Question: How do I go abour doing this?

Thankyou again I really need to figure this one out.
T

[pietlinden]

Access already does this. I don't understand what the problem is. You
type the first few letters of value you want from the list and then use
the up and down arrows to select from there. So why do you need the
mousewheel code at all?

[Mr. T]

I understand what you are talking about. But for what I am working on,
the people using it will be using their natural instinct to use the
mouse and I need to be able to handle that. Efficiency is key and
retraining a person who has been doing it one way is not going to to
work.

Is what I am asking for (to scroll with mouse wheel) within the
capabilities of ms access 97?

T

[pietlinden]

Mr. T wrote:

I understand what you are talking about. But for what I am working on,
the people using it will be using their natural instinct to use the
mouse and I need to be able to handle that. Efficiency is key and
retraining a person who has been doing it one way is not going to to
work.

Is what I am asking for (to scroll with mouse wheel) within the
capabilities of ms access 97?

T

So give 'em a good beating. remember, Pavlovian response.... shock
them when they misbehave and reward them when they do what you want...

Private Sub CountryName_GotFocus()
Me.CountryName.Dropdown
End Sub

[Mr. T]

OK,
Thanks, but I think I'll pass on beating them.

Anyway.
Actually you almost hit the nail on the head with .dropdown

I have been using this property and what I need is for them to be able
to type in for example two letters and then scroll though it with the
mouse wheel.
I understand that keyboard arrows will get the job done.
T

[pietlinden]

Now I'm confused. What version of Access are you using? I can scroll
through the values of the dropped down combobox no problem.
(Access2002) typing just jumps ahead to the next matching value. No
code required. Don't even need to type anyting into the combobox... it
just moves me to the part of the list I'm interested in.

[Mr. T]

I am using MS Access 97 sorry I should have stated that from the
beginning.
The database I have been working on, at this point has too many
stations and is too involved to be converted to a newer version.
T

[Larry Linson]

"Mr. T" wrote

I am using MS Access 97 sorry I should
have stated that from the beginning.
The database I have been working on, at
this point has too many stations and is
too involved to be converted to a newer
version.

I don't understand

(1) "has too many stations" -- what's a _station_?

(2) "too involved to be converted to a newer version"?

Larry Linson
Microsoft Access MVP

[Lyle Fairfield]

Mr. T wrote:

I understand what you are talking about. But for what I am working on,
the people using it will be using their natural instinct to use the
mouse and I need to be able to handle that. Efficiency is key and
retraining a person who has been doing it one way is not going to to
work.

Is what I am asking for (to scroll with mouse wheel) within the
capabilities of ms access 97?

I expect we'd all like to know how the users became habituated to using
the mouse wheel for scrolling through the offerings of a combo-box. How
did this happen?

In addition how do the users cope with standard Windows applications
including MS Office applications, and web/html pages.

[Mr. T]

Lyle Fairfield wrote:

>
I expect we'd all like to know how the users became habituated to using
the mouse wheel for scrolling through the offerings of a combo-box. How
did this happen?

Anyway we have kind of gone way off topic. But to answer both of your
question. I am a single college guy managing an entire network of 20
computer stations. Our original database was developped by another guy
about 5 years ago. I have taken his database and maniupalted it to the
database it is today. Anyway, upgrading is not feasable right now.

>
In addition how do the users cope with standard Windows applications
including MS Office applications, and web/html pages.

When you mean standard windows applications, the database is self
contained, to use excel spreadsheets by a way of manually creating csv
files and such. It has not need many other applications. I use forms
insted of web pages.

I don't want to give up on my idea of scrolling through combo boxes
yet. See I don't know what you guys all do, but part of my job is to
see how the user interfaces with the database and make it more user
friendly. Many people must be able to use it, even with just a little
training.

[Stephen Lebans]

I added this functionality to the MouseWheelHook solution on my site.
http://www.lebans.com/mousewheelonoff.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Mr. T" <ti*********@hotmail.comwrote in message
news:11*********************@75g2000cwc.googlegrou ps.com...

>
Lyle Fairfield wrote:

>>
I expect we'd all like to know how the users became habituated to using
the mouse wheel for scrolling through the offerings of a combo-box. How
did this happen?

Anyway we have kind of gone way off topic. But to answer both of your
question. I am a single college guy managing an entire network of 20
computer stations. Our original database was developped by another guy
about 5 years ago. I have taken his database and maniupalted it to the
database it is today. Anyway, upgrading is not feasable right now.

>>
In addition how do the users cope with standard Windows applications
including MS Office applications, and web/html pages.

When you mean standard windows applications, the database is self
contained, to use excel spreadsheets by a way of manually creating csv
files and such. It has not need many other applications. I use forms
insted of web pages.

I don't want to give up on my idea of scrolling through combo boxes
yet. See I don't know what you guys all do, but part of my job is to
see how the user interfaces with the database and make it more user
friendly. Many people must be able to use it, even with just a little
training.

[Bob Quintal]

"Mr. T" <ti*********@hotmail.comwrote in
news:11*********************@75g2000cwc.googlegrou ps.com:

>
Lyle Fairfield wrote:

>>
I expect we'd all like to know how the users became
habituated to using the mouse wheel for scrolling through the
offerings of a combo-box. How did this happen?

I don't want to give up on my idea of scrolling through combo
boxes yet. See I don't know what you guys all do, but part of
my job is to see how the user interfaces with the database and
make it more user friendly. Many people must be able to use
it, even with just a little training.

What Lyle and the others are trying to explain is that this
functionality does NOT exist in Windows XP, Excel, Word, or
MSIE.

If it doesn't work, how can you claim that users are habituated
to this behaviour?

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Mr. T]

Thanks Stephen,
This is right on track. I tried it, and it did just what I needed.
Thankyou for the hint.
T
Stephen Lebans wrote:

I added this functionality to the MouseWheelHook solution on my site.
http://www.lebans.com/mousewheelonoff.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Mr. T" <ti*********@hotmail.comwrote in message
news:11*********************@75g2000cwc.googlegrou ps.com...

Lyle Fairfield wrote:

>
I expect we'd all like to know how the users became habituated to using
the mouse wheel for scrolling through the offerings of a combo-box. How
did this happen?

Anyway we have kind of gone way off topic. But to answer both of your
question. I am a single college guy managing an entire network of 20
computer stations. Our original database was developped by another guy
about 5 years ago. I have taken his database and maniupalted it to the
database it is today. Anyway, upgrading is not feasable right now.

>
In addition how do the users cope with standard Windows applications
including MS Office applications, and web/html pages.

When you mean standard windows applications, the database is self
contained, to use excel spreadsheets by a way of manually creating csv
files and such. It has not need many other applications. I use forms
insted of web pages.

I don't want to give up on my idea of scrolling through combo boxes
yet. See I don't know what you guys all do, but part of my job is to
see how the user interfaces with the database and make it more user
friendly. Many people must be able to use it, even with just a little
training.