[AccessD] Pick a file, any file

If you click on an adjacent button to open the file, you can do this:

btn_Click()
	stgPath = [Full path to the file]
	btnOpenFile.HyperlinkAddress = stgPath

You could also experiment with an invisible button:

textbox_Click()
	stgPath = [Full path to the file]
	btnOpenFile.HyperlinkAddress = stgPath
	btn.Hyperlink.Follow

Windows will recognize what application should be used based on the
extension.

HTH!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Friday, June 05, 2009 3: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/>