Open Long Binary Object

  • Thread starter Thread starter Rob Reckard
  • Start date Start date
R

Rob Reckard

I have a table that contains files, primarily Office docs, JPGs, and HTMLs. I would like to be able to open those files from the form. I found and implemented code that allows me to save those files to disk but code that just opens the file eluding me. If someone could enlighten me or just point me in the right direction that would be awesome. I am, obviously, pretty weak when it comes to coding.


TIA
 
Hi Rob,

AFAIK your BLOB can't contain "files". Are we talking about the
*contents of a file*, or about an OLE object containing a *document*?

If the former, you have to create the file before you can open it. Save
the contents to a disk file and pass the filespec to
Application.FollowHyperlink

If the latter, use an Object Frame control (there are two flavours,
bound and unbound) on your form.


I have a table that contains files, primarily Office docs, JPGs, and HTMLs.
Click to expand...
I would like to be able to open those files from the form. I found and
implemented code that allows me to save those files to disk but code
that just opens the file eluding me. If someone could enlighten me or
just point me in the right direction that would be awesome. I am,
obviously, pretty weak when it comes to coding.
 
Forgive my ignorance on this, I believe they are the former and must be
re-created prior to opening.

thanks

--
Rob

Hi Rob,

AFAIK your BLOB can't contain "files". Are we talking about the
*contents of a file*, or about an OLE object containing a *document*?

If the former, you have to create the file before you can open it. Save
the contents to a disk file and pass the filespec to
Application.FollowHyperlink

If the latter, use an Object Frame control (there are two flavours,
bound and unbound) on your form.


I have a table that contains files, primarily Office docs, JPGs, and HTMLs.
Click to expand...
I would like to be able to open those files from the form. I found and
implemented code that allows me to save those files to disk but code
that just opens the file eluding me. If someone could enlighten me or
just point me in the right direction that would be awesome. I am,
obviously, pretty weak when it comes to coding.
 
Back
Top