Open a tiff file on my computer

[travismp]

I am sure this should be fairly easy, but I have never done it so I am not sure what the best way is.

I have a column in my DB called [INVOICEID]
I have a folder on my computer located at "C:/INVOICES/"
this folder is full of tiff files named the invoice number.

In my database when I am looking at a customer form I can see their invoice. I want to simply click a button & have a tiff viewer launch & show the matching invoice. What is the best way to do this?

I am running access 2003 thanks.

 

[pbaldy]

Look at FollowHyperlink and Shell in VBA help. I lean towards FollowHyperlink, as you don't have to specify the program.

 

[Kryst51]

Hi Travis, just FYI, it's considered impolite to double post. You can add more to your OP by editing or adding a new post to that thread. Good luck with your question.

Original Post

 

[travismp]

I did not mean to post the first thread. It posted before I was even finished typing. I deleted it. Sorry for that.


OK I will check out "FollowHyperlink" first and see what happens. Thanks.