Navigation

[ilanray]

Hi
I have a code that hide the navigation pane (workd great)>
The problem is in form, when I click Right Click on the tab it let the users edit the form. how can I disable the right click menu?

Docmd.ShowToolBar "Ribbon", acToolBarNo
docmd.NavigationTo("acNavigationCategoryObjectType")
docmd.RunCommand (acCmdWindowHide)

 

[GaP42]

Is this what you want?
https://www.access-programmers.co.u...e-right-click-close-menu.328536/#post-1887597

 

[CJ_London]

Or provide users with a .accde

 

[Isaac]

Am I the only one who clicked on this thread because I thought "Navation" was a cool new feature I didn't know about ?? Please!

 

[GaP42]

So you were hoping for the equivalent of the floating mountains in Access? What would that be? One touch web page generation/ interaction / db synchronisation?

 

[ilanray]

Am I the only one who clicked on this thread because I thought "Navation" was a cool new feature I didn't know about ?? Please!

I fixed is especially for you...

 

[mloucel]

Forms("FormName").ShortcutMenu = true ' Or False'

I use a tempvar to handle the boolean
so when your first form opens [in my case frmSplash on the Load event:
I set that form to:

Forms("Splash").ShortcutMenu = False

Then I create a Tempvar called SCM

Now in any form depending on the user level [in my case] either SuperAdmin=1, Admin = 2 , etc.
only SA has SCM = TRUE

Yes the ACCDE doest it, sort of, still has a right Click, this solves that problem.
I know there are many other ways and more fancy, but this works, and is easy to handle.

By the way the only caveat is that you have to use that 1 line of code in each form you open

Forms("FormName").ShortcutMenu = TempVars("SCM").Value

but is a small price to pay.

Master Guru Colin Riddington @isladogs has a great resource I use frequently:
https://www.isladogs.co.uk/control-application-interface/index.html