I have a form with table data in Datasheet view (looks like an Excel spreadsheet with rows and columns).
Access 2010 has a 'Delete' menu option if you right-click a datasheet column header.
How can I restore deleted columns when the database is re-opened?
OK
I found this:
http://stackoverflow.com/questions/770425/how-to-add-a-menu-item-to-the-default-right-click-context-menu
I created a custom shortcut menu using Access 2003 and it replaces the form shortcut menu but it DOES NOT replace the COLUMN right-click menu.
I am using Access 2010 - It only appears with Access 2010
I cant disable the whole menu because there are other options like 'Sort' that are needed in the menu.
Yes the table is the source for a subform control on the form.
When I run the form and right-click the column header it gives me the option to "Delete" the column.
I want this greyed-out.
How can you grey-out the 'Delete' option in the COLUMN right-click menu on a Table?
I have a form with a table on it.
How can I grey-out the 'Delete' option in the COLUMN right-click menu on the Table?
Additional Info for my question:
I am aware that the following code will prevent a user...