For years I've used an Access database to record purchases. I have a purchase order form which holds all the information about a purchase. The form includes one field which is setup as a "Hyperlink" data type. I can scan a receipt, save it as a PDF file and then drag the file to the Hyperlink field on the Access form. The local URL is automatically filled into the field and everything works great. Anyone on my local network can open a purchase order and by clicking the Hyperlink field the PDF file will open in a browser and they can see the original receipt.
Someone from a different office called me and asked about a purchase so I opened the database form, found the record pertaining to the purchase and printed the selected record as a PDF with the intent to mail it to them. I noticed as I viewed the PDF (purchase order) in Acrobat Reader I was still able to click the Hyperlink field and the receipt would open in a browser. So I manually edited the hyperlink address, in my access form, and changed it to fully qualified URL such as: http://companyServer.com/receipt/test.pdf
and it also works across the internet. (Of course I did some IIS stuff to set it up).
Finally to my question...When I drop a file on the Hyperlink control, how can I get the Hyperlink field to automatically change from: \\myserver\receipts\test.p
df to http://companyServer.com/receipts/test.pdf?
If I can get this to work I'll never have to turn in another receipt. I'll just email my purchase orders in as a PDF and they can click the hyperlink to see the original receipt. Any help would be greatly appreciated.