Access-->Word

[Sam]

Hi
I am trying to send the conents of a ole field to a word
file...How do I do this ..

My Application is supposed to let the user drag and drop
attachedments into an ole field. I jhave been able to
take care of the input. Now when the user tries to view
these records I want them to click on a button/hyperlink
to open a word document that contains the object(can be a
word/pdf/xls) in a new word window...I have been trying
to experiment with DDE functions but haven't been
successful as yet.

Please send your suggestions. Notify me
to my email-id if you have any suggestions.

Awaiting your reply.
thanx
sam

(e-mail address removed)

 

[John Nurick]

Hi Sam,

Storing documents in OLE fields is problematic because it tends to
produce an inordinately large mdb file (see
http://support.microsoft.com?id=123151), so it's often better just to
store the path to the document in a Hyperlink field. You can create the
links by dragging and dropping onto a textbox bound to the Hyperlink
field, and clicking on the textbox will then automatically launch the
document in its parent application.

With the OLE field, I guess you're using a BoundObjectFrame control to
drop the document into. To open the document in its parent application,
you need work with the BoundObjectFrame's properties. Typically you'd
set the Verb property to acOLEVerbOpen and then the Action property to
acOLEActivate: look it up in Help.

Hi
I am trying to send the conents of a ole field to a word
file...How do I do this ..

My Application is supposed to let the user drag and drop
attachedments into an ole field. I jhave been able to
take care of the input. Now when the user tries to view
these records I want them to click on a button/hyperlink
to open a word document that contains the object(can be a
word/pdf/xls) in a new word window...I have been trying
to experiment with DDE functions but haven't been
successful as yet.

Please send your suggestions. Notify me
to my email-id if you have any suggestions.

Awaiting your reply.
thanx
sam

(e-mail address removed)

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.