1) Problems opening OLE object 2) How to determine code behind menu items -
08-16-2010
, 12:22 PM
In 2003 application, I have a table with an OLE field containing Word
documents. I display that OLE field in a form, and I want to allow
users to open those documents. Double clicking is not sufficient
because that displays only about 2 inches worth of the document,
without even a vertical scrollbar.
Users do not have access to the menu bar. I can add the "Edit >
Document object > Open" menu item to my custom toolbar. (This is a
bit tricky because that menu item only shows up if the OLE object is
selected when you opt for customizing toolbars). HOWEVER, when I close
the database and re-open it, that toolbar button has disappeared.
(Other buttons that I added at the same time are still there.) The
same disappearing act happens when I try to add the toolbar button to
the shortcut menu. Any clue as to the lack of stickiness??
What I would REALLY like to do is identify the command that fires
behind "Edit > Document object > Open" so that I can fine tune its
use in VBA code -- especially since I also need a solution for a 2007
application, and we just don't want to get into that whole 2007
toolbar disaster, do we?
Could someone refer me to a reference document that would list
commands behind all of the various menu items?
Thanks!
pemigh |