OLE Activation

G

Guest

(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
 
G

Guest

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

Opening OLE Object Sync Issue within VBA Code 0
unbound OLE PDF Object in Access Report doesn't update 1
Open OLE Object 2
OLE 1
How to Link Outlook items to Access OLE field 9
Emailing OLE Objects 1
Changing OLE Links 2
Embeded Word document in Access 1

Top