Windows XP 
Access 2002 (version 10.0)
I am using Office 2013 Pro with Windows 8.1. I am new to this version of Access, but I have been using Access for years. I am not a programmer and have never used V Basic (maybe its time to learn it!). However, I have created a number of Databases that extensively use Queries, Macros, Reports and Forms that I have created without writing any code myself. I often use Combo Boxes on Forms to provide criteria to Queries and Command Buttons to run Macros which run the Queries and open new Forms or Reports whose source data comes from those Queries.
I cannot seem to be able to use the mouse wheel to scroll through records in Form View but have to click the back/forward arrows or use Page Up/Down to get to another record. No big deal, but I would like to be able to use the scroll wheel (which seems to be working fine for other things in Access as well as in other applications).
I have tried to assign an action to the mouse wheel via the Event Tab in the Properties window for a specific Form. It offers me the option of assigning a Macro to the mouse wheel but none of the Macro commands seem to be the one I need. I tried using FindNextRecord as a Macro command, but I was asked for search criteria when I tried to run the Macro. The Query on which the Form is based has already provided the search criteria, I just want to use the wheel to flip through the records!!
It seems to me that this issue should have a simple solution and that it could be solved globally for all Forms in the Database rather than resolved separately for each Form, but what do I know?.
Any suggestions??
Also, any suggestions for a good book to self-teach myself Visual Basic thoroughly enough to apply it to Access programming? (I assume that is still the language that this version of Access uses). I have programmed in the past using Pascal (I guess that dates me!), so I do understand the fundamentals of structured programming, but its been a while and never with V Basic.
Reply With Quote
