Right Click permanently diabled (1 Viewer)

JohnN2006 · Mar 20, 2006

Hi,

Somehow I have managed to permamently disable the right click on my version of Access.

I have been trying out numerous amounts of code to amend toolbars for a custom application that I am building. But I though I had reversed them all.

Luckily I have the code to enable the right click option but I have to run this each time I start Access - any ideas how I can set the right click option to enabled on a permanent basis ?

Thanks in advance for any help

RuralGuy · Mar 20, 2006

Open the db while holding down a <SHIFT> key and go to Tools>Startup... and check "Allow Default Shortcut Menus". Exit and then re-enter the db.

JohnN2006 · Mar 20, 2006

Thanks for the quick reply RG but it's stil not working.

Even when I open up a blank database and create a new table and then try and right click on that I still find that right click is disabled.

RuralGuy · Mar 20, 2006

How about a Repair Install?

JohnN2006 · Mar 20, 2006

I have done a total reinstall of Office but still no joy.

david.brent · Mar 20, 2006

Could it be your mouse? Does right clicking in another application work?

Sorry I know they are dumb questions but you never know.

Take care

RuralGuy · Mar 20, 2006

I'm out of ideas. Maybe some guru will stop by with some new suggestions. Sorry! Good luck. You've got a strange and stubborn problem.

ghudson · Mar 20, 2006

What code were you using to disable the right-click option?

This might help if you use the code to unhide all toolbars...
Hide all Access Toolbars and Menubars

The code only needs to be run once but I thought it was db specific, not for all Access db's on the users computer. Sorry but I do not have time to test it.

JohnN2006 · Mar 20, 2006

ghudson, It's definatley not yout code that is causing the problem.

I have to run your code to enable the right mouse click !

I was looking at the following code last week and lost all toolbars, when i restarted access the toolbars appeard to be back to normal, could this have anything to do with it ??

Option Compare Database
Option Explicit

Global Const SW_HIDE = 0
Global Const SW_SHOWNORMAL = 1
Global Const SW_SHOWMINIMIZED = 2
Global Const SW_SHOWMAXIMIZED = 3

Private Declare Function apiShowWindow Lib "user32" _
Alias "ShowWindow" (ByVal hWnd As Long, _
ByVal nCmdShow As Long) As Long

Function fSetAccessWindow(nCmdShow As Long)

Dim loX As Long
Dim loForm As Form
On Error Resume Next
Set loForm = Screen.ActiveForm

If Err <> 0 Then
loX = apiShowWindow(hWndAccessApp, nCmdShow)
Err.Clear
End If

If nCmdShow = SW_SHOWMINIMIZED And loForm.Modal = True Then
MsgBox "Cannot minimize Access with " _
& (loForm.Caption + " ") _
& "form on screen"
ElseIf nCmdShow = SW_HIDE And loForm.PopUp <> True Then
MsgBox "Cannot hide Access with " _
& (loForm.Caption + " ") _
& "form on screen"
Else
loX = apiShowWindow(hWndAccessApp, nCmdShow)
End If
fSetAccessWindow = (loX <> 0)
End Function

ghudson · Mar 20, 2006

Not sure where the problem is [I do not use that code] but have you tried to "reset" your toolbars?

Right click on the menu bar, then select the customize option, then you have to select each toolbar option "one at a time" and click the reset button to fix it.

JohnN2006 · Mar 21, 2006

I have reset every toolbar listed but the problem still remains.

I have even tried removing all office components and the deleting access items from the registry.

JohnN2006 · Mar 21, 2006

Right even further mystery to contend with.

I can right click on the toolbar and perform customisation on the toolbars. I just can't right click on the database window.

JohnN2006 · Mar 24, 2006

Right fianlly managed to sort this out, had to remove all office applications and then delete all registry items that related to Office. Followed by a complete re-install of Office.

Still dont know how this happend ! Hope nobody else has to go through it, just wanted to say thanks to the people who offered advice !

Right Click permanently diabled (1 Viewer)

JohnN2006

Registered User.

RuralGuy

AWF VIP

JohnN2006

Registered User.

RuralGuy

AWF VIP

JohnN2006

Registered User.

david.brent

Registered User.

RuralGuy

AWF VIP

ghudson

Registered User.

JohnN2006

Registered User.

ghudson

Registered User.

JohnN2006

Registered User.

JohnN2006

Registered User.

JohnN2006

Registered User.

Similar threads

Users who are viewing this thread