Group:  Microsoft Access ยป microsoft.public.access.forms
Thread: Make an OLE Object Read-Only and Undo any user changes programmatically.

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Make an OLE Object Read-Only and Undo any user changes programmatically.
"mnjkahn" <u27308[ at ]uwe> 29.09.2006 21:08:57
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.

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net