I recently discovered, that if you set the startup options for
"security", you will have alot of work do to get Access back to
"normal".
If you disable the built-in menus/toolbars you'll have to reconstruct
the one you want as a custom menu/shortcut(popup)/toolbar.
All this was a long journey in order to allow the user to sort/copy on
a datasheet view of a subform, with all the menus disabled in the
startup options.
I wanted to replace the built-in shortcuts when you right click on a
subform cell, row, or column and replace it with a custom menu. And I
discovered that there is more than one menu.
Following are the shortcut menus in question:
When Forms are used as Forms Only (Datasheet or Form View)
-------------------------------------------------
Datasheet View Column
Sort Ascending
Sort Descending
---------------
Copy
Paste
---------------
Column Widths
Hide Columns
Freeze Columns
Datasheet View Row
New Record
Delete Record
---------------
Cut
Copy
Paste
---------------
Row Height
Datasheet View Cell
Filter By Selection
Filter Excluding Selection
Filter For:
Remove Filter/Sort
---------------
Sort Ascending
Sort Descending
---------------
Cut
Copy
Paste
---------------
Insert Object
Hyperlink
When Forms are used as subforms Only
-------------------------------------------------------------------------
Datasheet View Subform Column (seem to replace "Datasheet View Column"
Subform Datasheet
---------------
Sort Ascending
Sort Descending
---------------
Copy
Paste
---------------
Column Widths
Hide Columns
Freeze Columns
Datasheet View Row (Same as above)
Datasheet View Cell (Same as above)
Now, if you disable shortcut menus in startup options and assign a
custom menu to a form, and if the form is used as a subform in
datasheet view, the custom menu will show only if you do row or cell
operations. Since it is a subform now, clicking on the column invokes
the "Datasheet View Subform Column", which it is disabled, so you will
not see a menu.
Using a form as a subform seems to revoke the "Datasheet View Column"
shorcut menu and points a column click to the "Datasheet View Subform
Column" shortcut menu.
This is confirmed by creating a simple form and viewing it in Datasheet
View, all the above shortcut menus are available except the "Datasheet
View Subform Column". Naturally, since the form is not being used as a
subform.
However, when you use the form as a subform in datasheet view the row
and cell menus are still available, but the "Datasheet View Column"
shortcut menu is now replaced with "Datasheet View Subform Column"
shortcut menu.
When shortcut menus are disabled with the startup options, and you've
assigned to the form your custom shortcut menu, row and cell operations
show the custom shortcut menu, however, since the built-in shortcuts
are now disabled a column click (which now points to "Datasheet View
Subform Column") does not work, in fact no shortcut is displayed.
So the question is, Is there a way to replace the "Datasheet View
Subform Column" with a custom menu and have it displayed appropriately?
This way, the user can right click on column, row, or cell and the
appropriate custome menu will show up. Users (IMHO) are more familiar
with right clicking columns to sort etc.
The subform doesn't have a shortcut menu bar property like the form, so
I am at a loss.
TIA