A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

scroll in mouse on a form



 
 
Thread Tools Display Modes
  #1  
Old November 10th, 2006, 06:01 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access.reports
00KobeBrian
external usenet poster
 
Posts: 77
Default scroll in mouse on a form

Hi,

How do I change the scroll action on a mouse when I open up an
Access form? Say instead of going to next record, it goes down the screen.
Please help. Thanks.


  #2  
Old November 10th, 2006, 10:05 AM posted to microsoft.public.access.forms
missinglinq via AccessMonster.com
external usenet poster
 
Posts: 545
Default scroll in mouse on a form

You really can't. You can disable the mouse wheel, which can really be
important in some apps (so that users don't accidentally move to another
record without realizing it) but you can't disable the move to next record
and at the same time allow it to scroll down the screen. To be honest, if you
have to scroll down the screen to see all of your form, you probably need to
look at your design! Maybe add a tabbed form control!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200611/1

  #3  
Old November 10th, 2006, 12:26 PM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access.reports
Arvin Meyer [MVP]
external usenet poster
 
Posts: 4,231
Default scroll in mouse on a form

You can't change the action, but you can turn it off:

http://www.lebans.com/mousewheelonoff.htm

Also, there is an older program named FreeWheel that may offer some help:

http://www.geocities.com/SiliconVall.../freewheel.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"00KobeBrian" wrote in message
...
Hi,

How do I change the scroll action on a mouse when I open up an
Access form? Say instead of going to next record, it goes down the screen.
Please help. Thanks.



  #4  
Old November 13th, 2006, 01:33 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access.reports
00KobeBrian
external usenet poster
 
Posts: 77
Default scroll in mouse on a form

So if this is used for multi-clients environment, I just need to put the dll
file to the same directory with the mdb and no need to put to the window
folder of every client machine and that should be fine, right? Thanks.


"Arvin Meyer [MVP]" wrote in message
...
You can't change the action, but you can turn it off:

http://www.lebans.com/mousewheelonoff.htm

Also, there is an older program named FreeWheel that may offer some help:

http://www.geocities.com/SiliconVall.../freewheel.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"00KobeBrian" wrote in message
...
Hi,

How do I change the scroll action on a mouse when I open up
an Access form? Say instead of going to next record, it goes down the
screen. Please help. Thanks.





  #5  
Old November 13th, 2006, 02:11 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access.reports
00KobeBrian
external usenet poster
 
Posts: 77
Default scroll in mouse on a form

I just tried it out. I think I need to include the dll to the mdb because
when I run the mousewheelon, it gave me "function not defined...". But when
I do it through tool-references and then browse and after I click the dll
file, it gave me "can't add a refence to the specified file" message. Can
you please help? Thanks. I using Access97 and MouseWheelHook97.zip .


"Arvin Meyer [MVP]" wrote in message
...
You can't change the action, but you can turn it off:

http://www.lebans.com/mousewheelonoff.htm

Also, there is an older program named FreeWheel that may offer some help:

http://www.geocities.com/SiliconVall.../freewheel.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"00KobeBrian" wrote in message
...
Hi,

How do I change the scroll action on a mouse when I open up
an Access form? Say instead of going to next record, it goes down the
screen. Please help. Thanks.





  #6  
Old November 13th, 2006, 03:07 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access.reports
Arvin Meyer [MVP]
external usenet poster
 
Posts: 4,231
Default scroll in mouse on a form

Hopefully, your database is split with a front-end on each workstation and
the data, if shared, on a server. You should not need to set a reference to
the dll, nor should you try to open the dll. Place a copy of the dll in the
same folder as your application's front-end. I'm not sure, but putting it in
the Windows\System32\ directory in addition or in place of the local folder,
should also work. When you open the form, put a boolean variable in the
form's declaration section and set the variable to MOUSEWHEELOFF in the form
open or load event.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"00KobeBrian" wrote in message
...
I just tried it out. I think I need to include the dll to the mdb because
when I run the mousewheelon, it gave me "function not defined...". But when
I do it through tool-references and then browse and after I click the dll
file, it gave me "can't add a refence to the specified file" message. Can
you please help? Thanks. I using Access97 and MouseWheelHook97.zip .


"Arvin Meyer [MVP]" wrote in message
...
You can't change the action, but you can turn it off:

http://www.lebans.com/mousewheelonoff.htm

Also, there is an older program named FreeWheel that may offer some help:

http://www.geocities.com/SiliconVall.../freewheel.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"00KobeBrian" wrote in message
...
Hi,

How do I change the scroll action on a mouse when I open up
an Access form? Say instead of going to next record, it goes down the
screen. Please help. Thanks.







  #7  
Old November 13th, 2006, 03:11 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access.reports
Douglas J. Steele
external usenet poster
 
Posts: 9,313
Default scroll in mouse on a form

If you're in a multi-user environment, the application should be split into
a front-end (containing the queries, forms, reports, macros and modules),
linked to a back-end (containing the tables and relationships). Only the
back-end should be on the server: each user should have his/her own copy of
the front-end, preferably on his/her hard drive. The DLL would be placed in
the same folder as the front-end database. In other words, yes, you need to
copy it to each client machine.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"00KobeBrian" wrote in message
...
So if this is used for multi-clients environment, I just need to put the
dll file to the same directory with the mdb and no need to put to the
window folder of every client machine and that should be fine, right?
Thanks.


"Arvin Meyer [MVP]" wrote in message
...
You can't change the action, but you can turn it off:

http://www.lebans.com/mousewheelonoff.htm

Also, there is an older program named FreeWheel that may offer some help:

http://www.geocities.com/SiliconVall.../freewheel.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"00KobeBrian" wrote in message
...
Hi,

How do I change the scroll action on a mouse when I open up
an Access form? Say instead of going to next record, it goes down the
screen. Please help. Thanks.







  #8  
Old November 13th, 2006, 03:14 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access.reports
Douglas J. Steele
external usenet poster
 
Posts: 9,313
Default scroll in mouse on a form

There's code that you need to copy from the sample database into your
database. I don't have a copy of the database handy, but there's at least a
class module that has to be copied.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"00KobeBrian" wrote in message
...
I just tried it out. I think I need to include the dll to the mdb because
when I run the mousewheelon, it gave me "function not defined...". But when
I do it through tool-references and then browse and after I click the dll
file, it gave me "can't add a refence to the specified file" message. Can
you please help? Thanks. I using Access97 and MouseWheelHook97.zip .


"Arvin Meyer [MVP]" wrote in message
...
You can't change the action, but you can turn it off:

http://www.lebans.com/mousewheelonoff.htm

Also, there is an older program named FreeWheel that may offer some help:

http://www.geocities.com/SiliconVall.../freewheel.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"00KobeBrian" wrote in message
...
Hi,

How do I change the scroll action on a mouse when I open up
an Access form? Say instead of going to next record, it goes down the
screen. Please help. Thanks.







  #9  
Old November 13th, 2006, 04:15 AM posted to microsoft.public.access.forms
missinglinq via AccessMonster.com
external usenet poster
 
Posts: 545
Default scroll in mouse on a form

"function not defined..." means you literally don't have a copy of the
function in your DB. About half of the people who are pointed at Lebans site
forget to import the module and get this message. After you've unzipped the
sample DB, go into your DB and import the module modMouseHook from the sample
DB.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200611/1

  #10  
Old November 13th, 2006, 04:39 AM posted to microsoft.public.access.forms
00KobeBrian
external usenet poster
 
Posts: 77
Default scroll in mouse on a form

Sorry, Guys. I need to import the module. It works now. THanks.


"missinglinq via AccessMonster.com" u28780@uwe wrote in message
news:6934c310fb7d2@uwe...
"function not defined..." means you literally don't have a copy of the
function in your DB. About half of the people who are pointed at Lebans
site
forget to import the module and get this message. After you've unzipped
the
sample DB, go into your DB and import the module modMouseHook from the
sample
DB.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200611/1



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.