• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 598
  • Last Modified:

Stop user moving to new records in subform PageDown

I have this that works great for keeping one record only in a subform.

If KeyCode = vbKeyPageUp Or KeyCode = vbKeyPageDown Then
    KeyCode = 0
End If

To my horror rolling the mouse scroller moves straight to the next records.

In my app that is a big problem. How do I stop it.
0
DatabaseDek
Asked:
DatabaseDek
  • 3
  • 3
  • 2
1 Solution
 
GozrehCommented:
Are you looking for solution to disable the mouse scroll in subform ?
look here  http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23662702.html
0
 
PatHartmanCommented:
Set the Cycle property of the form (Properties dialog - Other Tab) to Current Record.
0
 
DatabaseDekAuthor Commented:
Hi All

Setting the forms Cycle property to current record does not work with any mouse I have tried. Lebans system does not compile in 2002 and I cannot figure out why that is,

I'm still stuck. Any more suggestions?

Derek
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
GozrehCommented:
Which version of access are you using ? I test the Lebans with 2010 and it worked.
Did you download from Lebans the A2KMouseWheelHookVer22 file ? what error did you get ?
0
 
PatHartmanCommented:
Setting the forms Cycle property to current record does not work with any mouse I have tried.
We must live in different dimensions.  It works for me.  When you have a row selected in a subform, scrolling allows you to move the list up and down but focus stays on the selected record.  However, Page up and down WILL move focus to a different record.
0
 
DatabaseDekAuthor Commented:
I am on version 2002. My packaging and security software are linked to this version so an upgrade would be very inconvenient and expensive.

My subforms are in single form mode. Perhaps that is the difference. But this problem applies to all single forms in my app and all have the cycle property set to current record
0
 
PatHartmanCommented:
I think you must be using the version of access where cycle property is broken.  Lucky you.  The mouse wheel solution might work for you.  Otherwise, consider upgrading even though it will be inconvenient.
0
 
DatabaseDekAuthor Commented:
Thanks

Derek
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now