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