Results 1 to 9 of 9
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mouse Scroll Wheel Selects Previous Subform Record (2003)

    If, on the startup form of the attached mdb, you select 31st January 2006 and select the "Gruppo 5" tab, you can see that wheeling the mouse scroll wheel forward doesn't select a different record on the subform while it does if you wheel it backward. Is there a way to prevent the user from selecting a previous record(which is not in synch with the date selected on the main form calendar) by wheeling the wheel backward?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mouse Scroll Wheel Selects Previous Subform Record (2003)

    Do a search in this forum for mousewheel.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mouse Scroll Wheel Selects Previous Subform Record (2003)

    Thank you Hans, I went for the MouseHook DLL mentioned here,
    calling it from the Load event of the main form setting the NoSubFormScroll parameter to True but the previous record still gets selected when I wheel the mouse backward.
    What am I doing wrong?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mouse Scroll Wheel Selects Previous Subform Record (2003)

    Perhaps you should quit and restart Access. It works OK for me in your database.

    Have you made sure that the Mousehook.dll file is in the same folder as the database, or in your Windows System folder (C:WindowsSystem or C:WindowsSystem32 or C:WinNTSystem32 depending on your Windows version)?

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mouse Scroll Wheel Selects Previous Subform Record (2003)

    Yes, thank you Hans, quitting and restarting Access did the trick. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mouse Scroll Wheel Selects Previous Subform Record (2003)

    How come, when I click in the PSPOL text box on the startup form, the number is displayed with 3 decimals instead of 6?

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mouse Scroll Wheel Selects Previous Subform Record (2003)

    1) What does this have to do with mousewheel problems?

    2) When I open the form and click in PSPOL, it displays 6 decimals. e.g. 0.935000

  8. #8
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mouse Scroll Wheel Selects Previous Subform Record (2003)

    Sorry Hans, I thought since it's the same file I could get away with it <img src=/S/blush.gif border=0 alt=blush width=15 height=15>.
    It's odd though, the text box on my pc behaves as I've described while on one of my colleagues' that only has Access Runtime, it always displays the 6 decimals. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mouse Scroll Wheel Selects Previous Subform Record (2003)

    I'm sorry, I can't explain that - I tried your database in Access 2002 and in Access 2003, and both display 6 decimals, as specified by the format.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •