[AccessD] Pick a file, any file

Dear List:

I have a client who wants a list of file attachments as children to a parent
table.  No problem.  I get the path and file names  using the open file
dialog box.

But now he wants to be able to click the attachment text box (it contains
path and file name), and open the file with whatever program should open it
- .doc/.docx with word, .pdf with acrobat, .xls with Excel, .jpg with
whatever he's go it associated with, and any other file regardless of
extension (based perhaps on the association?).

Is there a way to general case this without knowing what application should
be used to open the attachment and exactly where the application is located?

MTIA

 

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/>