|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
I am embedding an OLE object (it may be Word or Excel, I won't know) in a field using a Bound Object Frame. Since I won't know the size of the object, I've chosen to display the icon for the application on the form. I want the user to be able to double-click and launch the original application in a new window to view the object. However, I don't want them to be able to update it once the record storing the object has been "approved" by a Manager. I can't set the Enabled property to No, since they need to be able to Activate the object to view it. If I lock the field, and/or the form, if the user updates the object, I get a message box stating "Microsoft Access can't save your changes to this bound OLE object...". Microsoft Knowledge Base article 93026 recognizes the situation, but doesn't address when the User has to activate the locked object to view it. Does anyone know how I can pre-empt the message, and undo the changes without the user having to go to the Edit menu and select Undo File/field changes?
I also need to disable the Save option in the File menu and the toolbar. If they actually save their changes Word doesn't close, even after clicking the close button, or selecting Close and return to Word. I have to cancel it using the Task Manager.
I'm using the AutoActivate property of the control to launch the application, which I recognize is probably part of my problem.
|
|
|