Has anyone stumbled on VBA coding that will disable the wheel scroll function on the mouse when using it in an Access database. I am using Access 2003. I was given some code for this by a friend and it worked on the first database I tried but none after. I keep getting a Compile error: Sub of Function not defined - even though I cut and paste the code from the database where it works.
Can anyone help? It'd be very much appreciated.
ok, might be a really silly question but is there anyway to stop your mouse scroller cycling the records on a form?
This is mainly a problem when in a sub form as when I use the scroller all the combo/text boxes go blank.
They dont lose this data but it's just annoying!
Hi all,
I have read much about disabling the mouse scroll bar - but my problem is that while I want the use of the scrollbar, it is very jumpy.
Does anyone know how I can control the functionality of the scroll bar?
Cheers
Robert
There must be a way to do this. I can't download the dll fix I've read about because of company policy...is there anything I can put in the following code which will force the subform to go back to the record or refresh the subform on the mouse wheel event?
Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long)
'MsgBox "Do Not Use Mouse Wheel To Navigate!", vbExclamation, "Mouse Trap"
Insert code here
End Sub
Sorry...fairly new to VB...still learning
:confused:
Hi
I have a problem, when on a form based on a table, scrolling the mousewheel will by default change the post shown, how can I disable that event ???
Im using Access XP..
I am a newbie to access programming...... I have forms, and while entering data in them, somebody scrolls the mouse, it does not save the information and starts showing all the records. I want to prevent thos mouse scroll event from happening.... i will ike to disable the mouse scroll event for my database.. Has some one run into this problem..... Please let me know, how i can take care of this..... I will really appreciate it..... Thanks
View 6 Replies View RelatedOn the database I am working on, it would not be convenient for me to install the mouse scrolling that determines if the mouse should scroll down the form, or to the next record.
That is a nice feature, but more than I need.
I only need to disable the mouse scroll bar (so the users do not get confused and then update the wrong record). Is there an easy way on the open of a form to completely disable the mouse scrolling feature?
Thank you,
TJ Bernard.
Hi,
I have a data entry form in Access 2000, and when people scroll the mousewheel or press tab enough times, all the data they've entered disappears! Is there anyway to prevent this? I have instructions on getting a .dll to block the mousewheel, but nothing for the tab, any help?
Anyone know what impact it would have to my table if people used mouse/tab to clear their data, and then added data to the blank form? I presme it's just creating a new record, but I could be wrong.
Thanks,
Toby
Hi,
Is it possible to use the mouse wheel go through a text box instead of using a vertical bar?
Thanks,
Le
i have a continuous form used for selling item , i want when the user selling item the scroll mouse working with the current record look the attachment to see how to fix the problem .
View 2 Replies View RelatedI have a form with four pages and subforms on each page. I am having issues with scrolling on pages 2-4. The first page will scroll correctly (to the bottom of the form), but the other pages will not scroll at all. I did enable the scroll bars on the subforms, but they will only scroll to the bottom of the viewable form, not the whole form, which I would prefer. Is there a way to scroll through the whole form on pages 2-4? I tried setting the focus to the form itself, but my code didn't work:
Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long)
Me.Parent.FRM_TABLE_TAB_1.SetFocus
End Sub
I would change the form; however, it is designed to look exactly like the actual questionnaire.
Hi!
I want to disable the usage of mouse scroll on my forms. Because, as things are now, you may accidently choose/ scroll to another Record/ Post, when editing data for one specific record.
How do I accomplish disabling usage of mouse scroll?
I have a form that opens to a NEW record, all fine and grand. there are a few drop down choices, and modern users are using the scroll button to try to move up and down the list in the drop down boxes, but this action actually tries to move to the next record, causing an error as fields are blank etc (which is fine) but its confusing everyone.
the nav buttons are not shown on the form, so what can we do to stop the form trying to goto another new record?
the form is opened using a macro, where the action is OpenForm (view=form, data mode=Add and window mode=Normal) GoToRecord (record=new).....
Is there a way to prevent a user from switching records on a single page form when he rolls his/her mouse wheel. I have noticed that users accidentally scroll the wheel, and this switches them to the next record.
I need for them to remain at the current record they have chosen, or at the new record they are working on.
I want to scroll through records in Access 2010 forms with the mouse scroll wheel.
View 10 Replies View RelatedI'm trying to disable mouse scroll wheel on the form but no luck here,
View 1 Replies View RelatedMy problem is that I have a couple of forms where scrollbars are not appearing on forms when they are too long to fit on-screen. Instead they're just going below the bottom of the screen and there's no way to access things at the bottom of the form. This is happening with a data input form as well as with a form I'm using to filter and display a report. I've tried selecting both "Vertical only" and "both" for the scrollbar property of the form, but it doesn't seem to make any difference.
The forms are being opened in "dialog" mode, the only option for opening a form in a web database when using a macro to open it, it seems. If I manually open the form in 'normal' mode, it has scrollbars. Also, if I open a report with a macro (on click), it has the option to open in 'normal' mode and has scrollbars and all is well. But if I want the user to be able to click a button to open the form, it seems I have to use dialog mode.
I have a form and in the form is a subform. When I add a record with the following code, the subform detail scrolls in such a way that you can't see the record you just added...only a single blank new record. Can you set the scroll position so that I can see all the previous records including the one I just added?
Private Sub Add_PROJ_RECORD()
On Error GoTo Err_Add_Click
Me.PROJECT_DATA.Locked = False
Me!PROJECT_DATA.SetFocus
DoCmd.GoToRecord , , acNewRec
Me.PROJECT_DATA.Form.PROJ = PROJ_COMBO
Me.PROJECT_DATA.Form.SPEC = SPEC_COMBO
Exit Sub
How can i disable the naviation i get on my form?
i have a form to add new records, if i accidently scroll the mouse i get previous records shown in the feild, so is it possible to disable the function?
Working in the theatreworld, I'm trying to create something which will usefully combine my contacts and also a database of which shows we have done (dates, actors involved etc, etc) and what shows we have bought in.
So far, I have created my form which has the usual fields (name, address and so on) and also a field which asks users to describe what type of contact they are ie. are they an actor, or a director, or a theatre company.
There are also two command buttons, which will either open up another form which lists all the productions they have been in with us over the years (In-house productions), or one that opens up another form which lists what shows each theatre company has brought to us.
I would like to be able to select 'actor' in the category field which will then enable the command button for me to see what productions that person has been in. Or if I selected the 'theatre company' category then the other button becomes enabled.
Can anybody advise me on this please? Alternatively, if this all sounds far too convoluted, then I am open to suggestions!
Many thanks in advance,
Popps
Is there any way I can disable a subform in my main form until the user has entered some data in the main form and thereby created a primary key?
If the user decides to enter data in the subform first it gives an error and obviously I don't want this!
Just wondered if you might be able to help. I have a form on which I would like to disable some comboboxes until a date box is filled in. Is this possible?
Not too hot with coding - but I have been trying and If Then Else method.
Is this the right way to go?
Thanks
Michelle
Just wondered if you might be able to help. I have a form on which I would like to disable some comboboxes until a date box is filled in. Is this possible?
Not too hot with coding - but I have been trying and If Then Else method.
Is this the right way to go?
Thanks
Michelle :confused:
Hi All,
I need some help. I want to disable the Escape key when users are entering data on a form. How can I do that?
Help apprecieted
Regards
K
We need a way to prevent confidential information from being printed.
We have secured the database application itself by disabling all print
commands except the ones we want, but PrintScreen still works fine.
We cannot use any system-wide disbaling of that key, because it is
the only way that users can print off screens from the BPCS terminal
program. We actually have a program that prints off a page directly
when the Print Screen button is pressed, and people have become
accustomed to using it.
I have searched this topic extensively and found nothing. The only
thing I can think of is to make a data access page and use
standard browser security code, but that would require an extensive
rewrite of our application.
Does anyone know how to disable the PrintScreen key from within the
database application? Thanks.
Hello i would like to ask if there is any way for me to enable the menus , the menu bar and the database window if i disable them from the startup options of my Db ?
View 9 Replies View Related