Just something I hate and been frustrated about and would like to know whether it can be solved. I don't know about your PC but my mouse's wheel does not work in the Visual Basic Editor. This applies to all Office apps.
When I scroll the wheel, nothing moves. It works great in other apps, though, such as Explorers, ....
Is it something that was meant at designed or am I missing something here?
Hello to all, Here is my questions : 1) Is it possible to enable/disable mouse wheel in modifiable list (combo box) ? In access2000 i can't select a record on the list with mouse wheel. 2) Same thing in a form. In a form the wheel is active to go to next or previous record but sometime would like to disable it. Thks in advance
hey all I am having a problem, and most people dont seem to know what to say and not to give me any ideas. So here we go. I have a form which you can scroll through the reocrds, with the mouse wheel, or through the navagation command buttons with I have created. However when I use my mouse wheel the record changes but it doesnt change my activeX Control. When I use my command buttons it changes. However I would like to have both the options so anyone have any ideas on how to get the activeX Control to change with the rest of my record?? Thanks
I have a form, that is longer than the height of the screen, so the user must scroll down to get to it all. If the user uses the scroll bar all is well. If they try to use their mouse wheel to go down the form jumps to the next record.
How can I stop the form from doing this. If it doesn't want to scroll down with the mouse wheel I can live with that, but it should not go to the next record with this.
Hi everyone. Listen, is there a way to disable the mouse wheel from scrolling through entries in a form? I would like to do this in order to not confuse and upset the user further in the database I am developing, since they do have to enter data into it. Please help me.
Well I'm having the all too common issue of the mouse wheel scrolling through all records in a form. However, I've decided to make light of the situation and adapt the form to the mouse wheel.
I have a list box on the form and whenever the user clicks on a record in the list, details about that record are displayed in the lower portion of the form. If the user scrolls, the detail portion of the record changes, but the original item remains highlighted in the list. I want to make it so that when users scroll, the selected item also changes to correspond with the item being displayed in the detailed view.
What I've thought of is to somehow relate the record in the detail view with the list index of the selected record. When the scroll wheel is used, the list index is changed to reflect the record in the detail view. I did something similar to save the record selection when switching between tabs, but I'm not too sure how to do what I want with the scroll wheel.
I've searched and so far haven't found anything. Any help would be appreciated
Hi everyone. Listen, is there a way to disable the mouse wheel from scrolling through enteries in a form? I would like to do this in order to not confuse and upset the user further in the database I am developing, since they do have to enter data into it. Please help me.
I have a form and I do not want the mouse wheel to move through the records - it is a single form view and I do not want the use to use the wheel as it corrupts my calculations.
Is there any way to allow input of numbers input without the wheeldoing anything
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:
My application retrieves a recordset with some records. Each record is presented separately on a form and there is a "next" button to move on. For each record it allows pressing a button on the form for activating MS Word that in turn opens a relevant document.
The problem is that while the MS Word document is open, mouse wheel scrolling scrolls the recordset in the MS Access application, so to move to other records, up or down. It is strange since the MS Word application is the active window at that time.
I would like to disable the mouse wheel for the MS Access while keeping it active for the MS Word. So a solution of disabling the mouse wheel totally is not what I'm looking for.
I am on a Invoice Header record in a bound form. I want to stop the user from scrolling the mouse wheel down, and land into a new record.
The problem is that when a user moves the mouse wheel, he lands into a new record, and access skips all data validations in the first record, and just commits it. I want to completely disable the mouse wheel. I have disabled the pageup and pagedown keys, but don't know how to stop the mouse wheel from scrolling.
i have searched the forums for hours but cant find an answer...
i have the mousewheel.dll to disable scrolling through records with the mouse. this works fine for my main form.
however when i click on my subform (continuous) and scroll it makes the records in the subform invisible. it does not delete them because they are still there next time i open the form.
Does anyone Know how to stop the mouse wheel from scrolling through the records, my Dbase is for non-computer expert users and the ability to move records to the EOF and see a blank freaks them out, does anyone know how to stop it from working, ???
Same for the Print screen, in normal MS applications the Print screen only records the screen to the Memory buffer, but on Access it actually prints the screen,
DO NOT ask me how the users are hitting the print screen button while inputting, its also a mistry to me :-)
I am a completely green when it comes to Access and MVB. I've surprised myself in creating the db and form.
My db is for troubleshooting outlet issues. I have a list of outlets and their various configurations. Users NEVER add or change any info. They select the outlet from a combo box and view the information. The problem is that you can move the wheel and change the outlet information being displayed but the combo box does not reflect the change; it continues to show the initially selected outlet name.
How do you get the combo box text to follow the mouse wheel?
I thought an easier solution would be to disable the mouse wheel, but in looking through this forum, apparently not.
Have any of you know a way (maybe in VBA modules) to deactive the use of MOUSE WHEEL while using on the MS Access form since I am creating a form for users to enter hundreds of project data into a project table.
I put certain contrainsts (force the users to enter data on several fields on the form and NOT to leave them blank).
However, the users can use the MOUSE WHEEL while on form to move to the next project WITHOUT entering those required fields?!!
By the way, each project is stored in separate record in its table. The form is a SINGLE FORM, not Continuous form.
Please help. I am looking forward to your reply. Thanks so much,
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'm not sure what you call it but I call it auto-complete; the functionality that gives you a list of methods/commands when you are typing something like Me.Forms. When you type the Me. after the . it will bring up a list for you to see what you can do from there. That works fine for me but when I do the following: "CoCmd." the list will popup for a brief moment (much less than half of a second) which does not let me view the possible methods. Is this normal? If not does anybody have any idea how I might be able to fix it short of reinstalling MS Office (that is NOT an option). Thanks, Aaron
I wasn't sure if it should go in this section or the VB section. I apologize if it is in the wrong section.
I have a form with a combo box and a button, which when clicked, opens a report based on the option selected in the combo box. For this, in the event procedure of the button click, how do I code it so that if no option is selected in the combo box and the button is clicked, it should display a 'message' as a pop up. I know I should use the MsgBox option but I seem to be going wrong with the If loops. I doubt I am positioning the MsgBox command in the wrong place in the code below, as it does not pop up the msg box as I desire. Heres the code:
Private Sub btnMarket_Click() If Me.Combo0 <> "" And Not IsNull(Me.Combo0) Then Dim s As String s = "1=1"