OLE Activation

L

Leif

(Sorry, this was mistaken posted under General questions. I've reposted here
since it is programming related).

First of all, perhaps I can save you a few hours. It took me several hours
to figure this out. You cannot embed an OLE image on a form (and the bound
field) if the form is in datasheet mode via VBA (you can do it using
drag-and-drop). You will get an error saying the OLE class is invalid. You
will need to change the form to form view. Once the object is embedded you
may switch the form to datasheet view.

My question is regarding activation. In datasheet view if I double click on
the OLE field the object (in my case a word document) is displayed in a
separate window. In form view if you double click the OLE field the object
is displayed in an "in-place" window. My in-place window is far too small to
effectively edit. Is there a way to force OLE to open the word document in a
separate window from form view? Thanks.

Regards,
Leif
 
L

Leif

Alex,

Thanks for your reply. Your suggestion should work, but...

it does not seem as flexible as having a normal Word window come up. If you
view the form in datasheet view, the OLE field is shown as "Microsoft Word
Document". If I double-click on that I get a full MS Word window displayed.
Do you think this is possible using form view and VBA?

Regards,
Leif
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OLE Word spelling 0
Word OLE to check spelling in text box 1
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
OLE Activation 0
Split form 0
Macro to copy table of contents to a new doc 0
Opening OLE Object Sync Issue within VBA Code 0
Chat application - OLE object and scrollbar 0

Top