[AccessD] Pick a file, any file

Jim Lawrence accessd at shaw.ca
Fri Jun 5 17:48:44 CDT 2009


Hi Rocky:

You can set up the system so that when a particular file is identified the
application associated with the file extension will initiate.

I have some code to that solution if you would like.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Friday, June 05, 2009 1:42 PM
To: 'Access Developers discussion and problem solving'
Subject: [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/> 

 

 





More information about the AccessD mailing list