Display .xls and .doc on form using http path

[srbond]

Hi,

I use an OLEUnbound control to preview .xls and .doc files using a UNC path
on an Access form without issue and it suits my needs perfectly... BUT I also
need to display .xls and .doc files using a http path.

The http path seems to fail with the OLEUnbound control properties, so I used
a webbrowser which displays the file, but enables the file to be edited -
which I do not want - I need it to behave the sames as the files previewed in
OLEUnbound, which is locked and double-click to open outside of Access.

Is there a way to display http file paths using OLEUnbound or lock the
webbrowser control?

Thanks much!

Scott

 

[HiTechCoach]

Hi,

I use an OLEUnbound control to preview .xls and .doc files using a UNC path
on an Access form without issue and it suits my needs perfectly... BUT I also
need to display .xls and .doc files using a http path.

The http path seems to fail with the OLEUnbound control properties, so I used
a webbrowser which displays the file, but enables the file to be edited -
which I do not want - I need it to behave the sames as the files previewed in
OLEUnbound, which is locked and double-click to open outside of Access.

Is there a way to display http file paths using OLEUnbound or lock the
webbrowser control?

Thanks much!

Scott

Scott,
To view the file in using the OLEUnbound method you first must Download the file from a URL (Click here)

I normally do this to a temp folder then delete it when finished. This is basically simulating what a web browser does when viewing a web page.