Launch file from OLE Field

[Sanya Ibrahim]

HI,
Is there any way to open a file I saved in an OLE field of Access 2007
using vba? For example, I saved a word document in the field using methods
as shown in http://support.microsoft.com/default.aspx/kb/210486. Now instead
of writing the file to disk, I want to open it in word using vba.
Can any one help?
Thanks in advance,
Sanya

 

[Stuart McCall]

HI,
Is there any way to open a file I saved in an OLE field of Access 2007
using vba? For example, I saved a word document in the field using methods
as shown in http://support.microsoft.com/default.aspx/kb/210486. Now
instead
of writing the file to disk, I want to open it in word using vba.
Can any one help?
Thanks in advance,
Sanya

Write the file to disk as usual, then open it using:

Application.FollowHyperlink "C:\Temp\MyFilename.doc"

(substitute your actual path of course)

 

[Alex Dybenko]

Hi,
have a look here:
http://accessblog.net/2006/04/how-to-open-document-in-ole-field.html

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com