By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,117 Members | 2,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,117 IT Pros & Developers. It's quick & easy.

Mousewheel from Lebans website

P: 66
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=MouseWheelOFF
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
Mar 31 '08 #1
Share this Question
Share on Google+
4 Replies


P: 66
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
Mar 31 '08 #2

P: 66
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!!
Mar 31 '08 #3

P: 66
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=mousewheelON/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!
Mar 31 '08 #4

missinglinq
Expert 2.5K+
P: 3,532
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)>
Mar 31 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.