KB278379 Response and Interpretation

[Mr. JYC]

Hello,

I received the following response. Since I am a newbie, I don't know
anything about the response, particularly the note. I just need to disable
scrolling in a form in Access 2000 or 2003 running on Windows XP workstations
that is why I am using KB278379. All I have is Visual Studio 2008 Standard.
My experience is in servers and databases with little knowledge of Microsoft
programming in VB or C++.

Please help.

Bill McCarthy wrote:

You can create COM callable dlls in VB.NET. That code, KB278379, should
update fine using the "Upgrade Visual Basic 6 Code" wizard from the Tools
menu; or manually replace Long with Int32 should pretty well cover it.
Note: there is no reason this code has to be an activex dll, unless your
project/calling code is VB6 or VBA perhaps. If your project is VB6 or VBA I
would use the approach as outlined in the KB. If it isn't then you probably
don't need a COM dll, and a pure .NET solution might fit your needs.

 

[Family Tree Mike]

Well, from what I can tell, this link,
http://support.microsoft.com/kb/278379/, covers how to disable the mouse
wheel from scrolling in MS Access. It does not say that it will work with
Access 2003, but hey, I guess there is a chance...

The artical describes two ways to code the solution, one in an ActiveX dll,
and the other in an Access VBA solution. If you are just worried about one
particular MDB file, then probably the VBA code will be fine. You add that
as code in your MDB file.

I believe that what Bill McCarthy was addressing is that from VS 2008, you
could write an application which handles the mouse wheel in its code without
the need from any of this source in the Knowledge Base article. You can
connect to, query, update, etc, an Access database from VS 2008. This
sounds beyond what you are wanting to get into however.

 

[Mr. JYC]

Thank you for the response.

How about if I did want to create an ActiveX dll using Visual Basic 2008?
What would I have to do? There is no ActiveX dll project option that I could
use. What should I do? Again, I am a newbie to VB .NET programming.
--
Thank you for your help!
JYC

Well, from what I can tell, this link,
http://support.microsoft.com/kb/278379/, covers how to disable the mouse
wheel from scrolling in MS Access. It does not say that it will work with
Access 2003, but hey, I guess there is a chance...

The artical describes two ways to code the solution, one in an ActiveX dll,
and the other in an Access VBA solution. If you are just worried about one
particular MDB file, then probably the VBA code will be fine. You add that
as code in your MDB file.

I believe that what Bill McCarthy was addressing is that from VS 2008, you
could write an application which handles the mouse wheel in its code without
the need from any of this source in the Knowledge Base article. You can
connect to, query, update, etc, an Access database from VS 2008. This
sounds beyond what you are wanting to get into however.

 

[Family Tree Mike]

You can make a COM compatible dll by checking the box for "Register for COM
Interop". ActiveX usually means an COM compatible controls for a web
application. You could create a Class Library project. I'm sorry, but I
don't recall the specifics in VS 2003.

Thank you for the response.

How about if I did want to create an ActiveX dll using Visual Basic 2008?
What would I have to do? There is no ActiveX dll project option that I
could
use. What should I do? Again, I am a newbie to VB .NET programming.