Disable mouse tracker ball

[Guest]

Hiya

I have a form for users to enter data into. I don't want them to be able to cycle to other records using the form though

Although I have disabled what I can (certain features can't be since I need the form to be able to add a new form), the problem is that using the scrolling wheel on a mouse you can still cycle through records. Is there any way to disable this

Thanks

Basil

 

[Cheryl Fischer]

Sure. Access MVP Stephen Lebans has a downloadable example of how to do
that at:

http://www.lebans.com/mousewheelonoff.htm



--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

Hiya,

I have a form for users to enter data into. I don't want them to be able

to cycle to other records using the form though.

Although I have disabled what I can (certain features can't be since I

need the form to be able to add a new form), the problem is that using the
scrolling wheel on a mouse you can still cycle through records. Is there
any way to disable this?

 

[Guest]

Nice one!

Thanks Cheryl

----- Cheryl Fischer wrote: ----

Sure. Access MVP Stephen Lebans has a downloadable example of how to d
that at

http://www.lebans.com/mousewheelonoff.ht



-

Cheryl Fischer, MVP Microsoft Acces
Law/Sys Associates, Houston, T

Hiya

need the form to be able to add a new form), the problem is that using th
scrolling wheel on a mouse you can still cycle through records. Is ther
any way to disable this

 

[Tim Ferguson]

I have a form for users to enter data into. I don't want them to be
able to cycle to other records using the form though.

I set the recordsource of the form to a single record either in the calling
code or in the Form_Open event:

strSQL = "SELECT * FROM SomeTable " & _
"WHERE RecordID=" & GetRecordNumber() & ";"

Me.Recordsource = strSQL

or

strWhere = "RecordID=" & GetRecordNumber() & ";"

' can't remember how many commas
DoCmd.OpenForm "frmSomeForm",,strWhere,,

It's kinder to the network too.

HTH


Tim F

 

[Guest]

Thanks Tim

I agree and I am working on that too

----- Tim Ferguson wrote: ----

able to cycle to other records using the form though.

I set the recordsource of the form to a single record either in the calling
code or in the Form_Open event

strSQL = "SELECT * FROM SomeTable " &
"WHERE RecordID=" & GetRecordNumber() & ";

Me.Recordsource = strSQ

o

strWhere = "RecordID=" & GetRecordNumber() & ";

' can't remember how many comma
DoCmd.OpenForm "frmSomeForm",,strWhere,,

It's kinder to the network too

HT


Tim