Mousewheel from Lebans website

[limperger]

Hello everybody!

I know some Access fundamentals but I have no idea about VBA code. As many people, I would like to have something to fix the mousewheel "effect" in Access forms. I have entered into the Lebans web site and have downloaded the 97 version of the mousewheel DLL. As it seems, you only have to paste the DLL either in the system folder or in the folder where you have your Database (as I have done). Then, it seems, you just only have to type the following code (as a Private Sub as a Form_Load event or in a commandbutton):

Dim blRet as boolean
blRet = MouseWheelON or blRet=MouseWhee lOFF
End Sub

As I understand it, this is all that you would have to do. But having proceeded this way, the problem is by no means solved. Could anybody here explain me whether I have missed something (I'm afraid that is for sure!!) or whether there is any thread here specifically discussing this problem (using the Lebans DLL)??

Thank you very much in advance

Best regards from Barcelona

[limperger]

As an addendum, let me specify that, as I understand it, no additional VBA module, other than the code aforementioned, is needed. This is not the case, as it seems to me, to more advanced Access versions, where, apart from the code, an addition of a special VBA module is required.

Again, thank you much in advance.

Best regards

[limperger]

As an addendum, let me specify that, as I understand it, no additional VBA module, other than the code aforementioned, is needed. This is not the case, as it seems to me, to more advanced Access versions, where, apart from the code, an addition of a special VBA module is required.

Again, thank you much in advance.

Best regards

Of course, I am working with the 97 Access version. An additional VBA module is needed in this case?

Thank you very much for your attention!!

[limperger]

Of course, I am working with the 97 Access version. An additional VBA module is needed in this case?

Thank you very much for your attention!!

I am happy to anounce that I have solved the problem, as for the 97 version and later ones. What was missing was the specific VBA module, apart from the blret=mousewhee lON/OFF statements.
I find that in the Lebans web, the need for the module, aside from the Blret - MousewheelON/OFF, is not clearly stated, at least for a person like me, with no code idea.

Thank you very much for your attention.

See ya soon!

[missinglinq]

Don't feel bad, my friend! About 75% of the people who use Stephen's excellent hack forget to import the module into their own database!

It's a good idea, any time you download a sample database that demonstrates how to solve a major problem like this, to check the Modules tab on the Access objects dialog box. If the problem necessitates downloading an entire db, as opposed to simply copying and pasting code from a developer's site, a module is probably involved.

Also note, that if a site does list the code for the function to be copied, along with instructions to paste it into a free-standing module, that when Access prompts you to name this standard (free-standing) module, do not give it the same name as the function itself! This confuses the Access gnomes no end, and will cause the function to fail!

Welcome to TheScripts!

Linq ;0)>