Virus Security Warning Opening PDF

[mcktigger]

Hi All

I have a cmd button that opens pdf files saved on the server. This works fine on a number of PCs but on 1 machine the user keeps getting the warning:

Opening server\xxxx\xxxx

Some files can contain viruses or otherwise be harmful etc etc

Would you like to open this file - Yes / No

The file is opened using the following code to construct the file name so it does not use a hyperlink field on the form which I know is a problem.


stCompanyName = "Haulage"
stPricingFile = Me.PricingId & stCompanyName
stFileName = "S:\CRMQuotes\" & stCompanyName & "\PricingMatrix\" & stPricingFile & ".pdf"
Application.FollowHyperlink stFileName

Macro security is set to low. Any help would be appreciated.

Thanks

 

[vbaInet]

Use the following to open your pdf:

http://access.mvps.org/access/api/api0018.htm