Search results

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?

My next question is this: If users can delete columns, How can I restore all deleted columns when the database is re-opened by the next user?

It appears in BOTH (Access 2010 only)

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 looking for a way to directly grey-out the default menu without creating a new 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.

Yes. I have a Form with a Table on it. How can you grey-out the 'Delete' option in the COLUMN right-click menu on a TABLE?

I was providing information to my question...not answering it. My question was on COLUMNS.....I was providing information on ROWS.

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...