Allow right-click

[Bizkaiko]

I created a locked database, I've hidden the menu bar and disallowed the right-click for all the users.
The problem is that some users need to use the right-click to filter the data they can see (i.e. the results of a query): is it possible to give 'em the possibility to filter all they want without displaying all the menu of access?

 

[dt01pqt]

What exactly are you trying to achieve by not allowing them to right click?

 

[Pauldohert]

Create a custom shortcut menu bar - ctl & f2 allows you to copy buttons from other toolbars - so you can pick exactly what your user will get.

 

[Bizkaiko]

I created the shortcut menu bar as you said and selected it in the forms properties: the problem is that I disabled all the menu and toolbars using the code
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
opening the database, so now the right-click is disabled and I don't know how to allow it only in the form I need, to display the shortcut menu I created

 

[Bizkaiko]

Solved:
the code to use was simply
Application.CommandBars("ToolbarName").Enabled = True
Thanks!