developingprogrammer
asked on
cannot right click in VBE
hey guys,
something a little strange happened. now when i try to right click in VBE (to copy and paste or add a variable to watch) nothing happens.
essentially my right clicking ability is taken away. however if i press the right click key on the keyboard, the right click menu pops up as usual.
i found and article that is similar to my situation but that poster's issue was in Excel. i'm Access.
any ideas guys? thanks!! = )
http://www.mrexcel.com/forum/excel-questions/420309-right-click-menu-gone-vbe.html
something a little strange happened. now when i try to right click in VBE (to copy and paste or add a variable to watch) nothing happens.
essentially my right clicking ability is taken away. however if i press the right click key on the keyboard, the right click menu pops up as usual.
i found and article that is similar to my situation but that poster's issue was in Excel. i'm Access.
any ideas guys? thanks!! = )
http://www.mrexcel.com/forum/excel-questions/420309-right-click-menu-gone-vbe.html
ASKER
Hi Joe! Thanks for your help! I tried what you suggested in the other post, and yes to nth questions I can right click and I can see shortcut menus but it doesn't fix the problem = (
What version of Access are you using?
ASKER
hey Dale! i'm using Access 2007!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Do you have any addins that impact the VBE? If so, try disabling those (you may need to restart Access after doing so).
As always, be sure that your Windows and Office installs are fully up to date.
As always, be sure that your Windows and Office installs are fully up to date.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"this is a problem the VBA editor has at least since Office 2007 (can't remember if it was also the case in former versions). The longer you work with the VBA editor and the more you open and close it or work with other VBA editors like Excel VBA at the same time the more the VBA editor's ressources get corrupted"
I work in the VBA IDE almost daily ... as in all the time, and I have never ever had this issue ... and I right click constantly. So ... I don't see this as very common.
"I think the effect is more often the more add-ins you have installed which inserts something into the context menu."
I have approx 10 VBA Add Ins, several of which add items to the right click menu ... and again, no issue.
Just sayin' ...
m
I work in the VBA IDE almost daily ... as in all the time, and I have never ever had this issue ... and I right click constantly. So ... I don't see this as very common.
"I think the effect is more often the more add-ins you have installed which inserts something into the context menu."
I have approx 10 VBA Add Ins, several of which add items to the right click menu ... and again, no issue.
Just sayin' ...
m
I haven't seen any issues either, but then I typically don't work with multiple editors.
Jim.
Jim.
ASKER
hey everyone! thanks SO much for your help AS ALWAYS!!
i did some testing and what yall said was exactly correct!!
dear Jim, yes it is due to the multiple monitors i'm using. when i switch the VBE back to the primary screen i can right click and it works.
dear Scott, thanks and yes i tried disabling the things but didn't work, it was due to the multiple monitors = )
dear Christian, yes you are absolutely spot on - this problem only occurred recently (i guess due to the accumulation of corruption) and what i've noticed is that on some areas of my secondary monitor (namely the lower half) i can right click no issues, but the top half i can't right click.
dear Joe, i need to upgrade to your computer!!! it is obviously better than my Lenovo X220 haha since it's giving me this right clicky problem!! = P and the Lenovo X220 that my organisation uses can't use the pointing stick mouse buttons and the track pad at the same time!! = ((
guys thanks once again so much, yall have SOLVED this esoteric problem once again!!
i did some testing and what yall said was exactly correct!!
dear Jim, yes it is due to the multiple monitors i'm using. when i switch the VBE back to the primary screen i can right click and it works.
dear Scott, thanks and yes i tried disabling the things but didn't work, it was due to the multiple monitors = )
dear Christian, yes you are absolutely spot on - this problem only occurred recently (i guess due to the accumulation of corruption) and what i've noticed is that on some areas of my secondary monitor (namely the lower half) i can right click no issues, but the top half i can't right click.
dear Joe, i need to upgrade to your computer!!! it is obviously better than my Lenovo X220 haha since it's giving me this right clicky problem!! = P and the Lenovo X220 that my organisation uses can't use the pointing stick mouse buttons and the track pad at the same time!! = ((
guys thanks once again so much, yall have SOLVED this esoteric problem once again!!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
" it's very common...:-)"
I have never seen it happen in 22 years of working with VBA.
Also, I have been using dual monitors on all of my systems since the concept was invented ... never an issue.
So yes ... maybe Regional.
mx
I have never seen it happen in 22 years of working with VBA.
Also, I have been using dual monitors on all of my systems since the concept was invented ... never an issue.
So yes ... maybe Regional.
mx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"As you know you can move the relational positions of the extended desktops of the other monitors so if you move the mouse horizontally it seems that it moves in one line without jumping up or down when it enters the next monitor."
Where is this setting ?
Where is this setting ?
Hi Joe,
depending on your Windows version it's there where you can change the screen resolution. You'll see all monitors in a small graphic where you can click each to change it's resolution, but you cannot only click on them or identify each, you can also move the screens to change the relational position.
The picture above is a hardcopy of this setting from Windows 7. In other versions it looks slightly different.
Cheers,
Christian
depending on your Windows version it's there where you can change the screen resolution. You'll see all monitors in a small graphic where you can click each to change it's resolution, but you cannot only click on them or identify each, you can also move the screens to change the relational position.
The picture above is a hardcopy of this setting from Windows 7. In other versions it looks slightly different.
Cheers,
Christian
ahh ... right (I'm all on Win7). Let me try that in the am at work tomorrow and get back to you. Guess it's already tomorrow for you ?
It depends on what is today for you...;-)
Right now it is 18th April at 18:19.
Right now it is 18th April at 18:19.
BSQ (Bitsqueezer) ... Sorry ... I will check that a work on monday ...
mx
mx
@ Christian ...
OK ... Played around bit the relative position (on examples below), but I was unable to reproduce the behavior - but I do believe you :-)
I assume this is what you were referring to ?
Having the two displays offset like that is quite confusing relative to mouse movement, lol.
mx
OK ... Played around bit the relative position (on examples below), but I was unable to reproduce the behavior - but I do believe you :-)
I assume this is what you were referring to ?
Having the two displays offset like that is quite confusing relative to mouse movement, lol.
mx
Hi Joe,
thanks for the test, yes, that's what I meant above. I can reproduce this behaviour today again, but I reboot my computer very rarely, mostly I'm using hibernation so it is possible that this only appears when the system memory rans out of space.
I tried today with this setting:
In monitor 3 the menu cannot be opened, in 2 only in the lower half and in 1 on the complete screen. If I swap 1 and 3 so that 3 is below 1 then the menu is available in 3 completely... funny.
In this setting it is also possible to have one VBA window over all three monitors at the same time and it's the same like described above.
Yes, you can really confuse someone who's working with two monitors if you move monitor 2 to the left side and 1 to the right side or one above the other, it'll take a time in many cases until they are able to "repair" this...;-)
Cheers,
Christian
thanks for the test, yes, that's what I meant above. I can reproduce this behaviour today again, but I reboot my computer very rarely, mostly I'm using hibernation so it is possible that this only appears when the system memory rans out of space.
I tried today with this setting:
In monitor 3 the menu cannot be opened, in 2 only in the lower half and in 1 on the complete screen. If I swap 1 and 3 so that 3 is below 1 then the menu is available in 3 completely... funny.
In this setting it is also possible to have one VBA window over all three monitors at the same time and it's the same like described above.
Yes, you can really confuse someone who's working with two monitors if you move monitor 2 to the left side and 1 to the right side or one above the other, it'll take a time in many cases until they are able to "repair" this...;-)
Cheers,
Christian
ASKER
Whao Christian!! I think you may have found the root cause of the problem!! I too seldom reboot my computer, choosing just to shut the lid and let it sleep.
I think when it runs out of memory this right click problem thing happens cause I don't remember it being a constant problem, an occasional one though.
I think when it runs out of memory this right click problem thing happens cause I don't remember it being a constant problem, an occasional one though.
Hi developingprogrammer,
it cannot be only that because due to automatic updates I was forced to reboot my computer today but the problem is still the same directly after starting the first VBA window. Memory may be one indicator but as Joe doesn't have this problem it must be an additional problem, I guess it's really something regional.
Cheers,
Christian
it cannot be only that because due to automatic updates I was forced to reboot my computer today but the problem is still the same directly after starting the first VBA window. Memory may be one indicator but as Joe doesn't have this problem it must be an additional problem, I guess it's really something regional.
Cheers,
Christian
https://www.experts-exchange.com/questions/28405203/right-click-not-working.html?anchorAnswerId=39978781#a39978781
mx