Disaplaying jpegs from hyperlinks 1

[NWTrust]

I have been asked to set up a d/b of photographs (jpegs). The form displaying the details also shows a thumbnail of the picture obtained via a hyperlink. The hyperlink field is 'Link' and contains the address (local) of the jpeg. I want double clicking the displayed thumbnail (code 'Application.Followhyperlink Me![Link]') to open the jpeg in Photoshop allowing editing. This works fine on my own PC (non network) but on the customer's PCs (networked) the picture opens in Internet Explorer (I think) which doesn't allow editing etc. In normal use jpegs on the customer's system are set to open in Photoshop and do! Can anyone help me here, please?

 

[PHV]

You may try this:
Dim WS As Object
Set WS = CreateObject("WScript.Shell")
WS.Run Chr(34) & Me![Link] & Chr(34)
Set WS = Nothing

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[NWTrust]

Thanks, PHV. After a lack of activity for various reasons I have at last got around to applying your suggestion and it has solved my problem. Thanks again.