scroll wheel help

[Guest]

I removed the record navagation buttons and text boxes. instead i have a
combo box with the primary key for each record. i then use the code

Me.RecordsetClone.FindFirst "[CoilID] = '" & Me![CoilIDCombo] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark

to change the recordset when the combo box value changes. i.e. update the
fields with the record associated with the combo box value.

i found that if i use my scroll wheel, i can go through the recordset w/o
changing the value of the combo box.

Is there a way to either disable the scroll wheel functionality, or better
yet, on the wheel up/down event change the value in teh combo box?

Thankx

 

[Ken Snell \(MVP\)]

See www.lebans.com/mousewheelonoff.htm

 

[Guest]

Hi Mike,

Unfortunately, I had the same problem with my app a little while ago.
According to the feedback I got, the answer is not easy. It involved
installing a special .dll file on the user's computer. I thought there would
have been a property in Access that would remove the wheel functionality but
that's not the case. Do a search on msdn, there's an article somewhere that
explains how, in detail.

Ray

 

[Guest]

did you see the secomd part of my question? if i can't disable the wheel,
i'd like the field to update as the wheel scrolls through the records.

I did find that doing the active x/dll thing would be a pain in the
but....however i found the better solution.

i just have the OnCurrent event for the form set to

CoilIDCombo = [CoilID]

this way, the current value of the coilid is always displayed in the combo
box. but thanx tho

See www.lebans.com/mousewheelonoff.htm

--

Ken Snell
<MS ACCESS MVP>

I removed the record navagation buttons and text boxes. instead i have a
combo box with the primary key for each record. i then use the code

Me.RecordsetClone.FindFirst "[CoilID] = '" & Me![CoilIDCombo] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark

to change the recordset when the combo box value changes. i.e. update the
fields with the record associated with the combo box value.

i found that if i use my scroll wheel, i can go through the recordset w/o
changing the value of the combo box.

Is there a way to either disable the scroll wheel functionality, or better
yet, on the wheel up/down event change the value in teh combo box?

Thankx

 

[Ken Snell \(MVP\)]

Stephen Lebans' solution does not use an ActiveX control; just a dll file
that is put in the same folder as the database file, and some simple VBA
code.

You will be better served if you disable the wheel, as leaving it active
means that users can inadvertently scroll from one record to another, and
then be editing a different record than anticipated. Lots of data problems.

If you want the combo box in the header to be updated as the form's records
are scrolled, you'd need to use code in the form's Current event to write
the record's value into the combo box, as you've noted.
--

Ken Snell
<MS ACCESS MVP>

did you see the secomd part of my question? if i can't disable the wheel,
i'd like the field to update as the wheel scrolls through the records.

I did find that doing the active x/dll thing would be a pain in the
but....however i found the better solution.

i just have the OnCurrent event for the form set to

CoilIDCombo = [CoilID]

this way, the current value of the coilid is always displayed in the combo
box. but thanx tho

See www.lebans.com/mousewheelonoff.htm

--

Ken Snell
<MS ACCESS MVP>

I removed the record navagation buttons and text boxes. instead i have
a
combo box with the primary key for each record. i then use the code

Me.RecordsetClone.FindFirst "[CoilID] = '" & Me![CoilIDCombo] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark

to change the recordset when the combo box value changes. i.e. update
the
fields with the record associated with the combo box value.

i found that if i use my scroll wheel, i can go through the recordset
w/o
changing the value of the combo box.

Is there a way to either disable the scroll wheel functionality, or
better
yet, on the wheel up/down event change the value in teh combo box?

Thankx

 

[Guest]

ahh, ok. Thanks for the input. I'll take a look at it again. However, the
form i'm using isn't being used for data entry. it's more of a way to read
the data already in the system.

Thanks

Stephen Lebans' solution does not use an ActiveX control; just a dll file
that is put in the same folder as the database file, and some simple VBA
code.

You will be better served if you disable the wheel, as leaving it active
means that users can inadvertently scroll from one record to another, and
then be editing a different record than anticipated. Lots of data problems.

If you want the combo box in the header to be updated as the form's records
are scrolled, you'd need to use code in the form's Current event to write
the record's value into the combo box, as you've noted.
--

Ken Snell
<MS ACCESS MVP>

did you see the secomd part of my question? if i can't disable the wheel,
i'd like the field to update as the wheel scrolls through the records.

I did find that doing the active x/dll thing would be a pain in the
but....however i found the better solution.

i just have the OnCurrent event for the form set to

CoilIDCombo = [CoilID]

this way, the current value of the coilid is always displayed in the combo
box. but thanx tho

See www.lebans.com/mousewheelonoff.htm

--

Ken Snell
<MS ACCESS MVP>

I removed the record navagation buttons and text boxes. instead i have
a
combo box with the primary key for each record. i then use the code

Me.RecordsetClone.FindFirst "[CoilID] = '" & Me![CoilIDCombo] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark

to change the recordset when the combo box value changes. i.e. update
the
fields with the record associated with the combo box value.

i found that if i use my scroll wheel, i can go through the recordset
w/o
changing the value of the combo box.

Is there a way to either disable the scroll wheel functionality, or
better
yet, on the wheel up/down event change the value in teh combo box?

Thankx