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

[NTC]

you probably want to use the hyperlink field type in the underlying table i.e. add a new field - - to hold xls and other doc links.

the reason is that xls and pdf and some others are in fact complex programs unto themselves and really should not be considered a simple 'image'. when you use the hyperlink method - upon click it will actually launch the application itself.

[pkstormy]

You can also use code as such:

Dim strURL as variant
strURL = "UNCNameHereToTheExcelFile"
Application.FollowHyperlink strURL