Open files from Access Form

[Guest]

Hello all,

One field of my table contains a link to an attached file. This file may be
a word doc, pdf, or other.

How could get Access to open the file using the appropriate program (ie
Word, Acrobat..etc) automatically when I click a button.

I know how you could specify a particular program, say word, to open a
link... But not sure how I could do a pdf. And how I could get it to
determine default program settings.

Thanks for your help.

 

[fredg]

Hello all,

One field of my table contains a link to an attached file. This file may be
a word doc, pdf, or other.

How could get Access to open the file using the appropriate program (ie
Word, Acrobat..etc) automatically when I click a button.

I know how you could specify a particular program, say word, to open a
link... But not sure how I could do a pdf. And how I could get it to
determine default program settings.

Thanks for your help.

You don't need to specify the program. The file extension will
determine what program opens the file.

For example, code the click event of a command button:

Application.FollowHyperlink "PathToFile\FileName.pdf"

The .pdf extension will cause the file to open with Adobe Acrobat.

 

[John W. Vinson]

Hello all,

One field of my table contains a link to an attached file. This file may be
a word doc, pdf, or other.

How could get Access to open the file using the appropriate program (ie
Word, Acrobat..etc) automatically when I click a button.

I know how you could specify a particular program, say word, to open a
link... But not sure how I could do a pdf. And how I could get it to
determine default program settings.

Thanks for your help.

Consider storing Hyperlinks to the files. Windows will open the appropriate
program for the file type.

John W. Vinson [MVP]

 

[Guest]

John
How would I do that? And what would be the "open" command?

Fred
Does this command work if the filepath is stored as a text?

 

[fredg]

John
How would I do that? And what would be the "open" command?

Two for the price of one today?
You can store the path and file name as a Hyperlink field.
Look up Hyperlink in Access Help.
Clicking on the field will open the file.

Alternatively, you can store the path and file name as a Text
datatype.
Then code the double-click event to open the file using the
FollowHyperlink method.

Fred
Does this command work if the filepath is stored as a text?

Application.FollowHyperlink [Name of Control that stores the Path] &
"\MyFile.pdf"

 

[Peter Hibbs]

If you don't want to use a Hyperlink type control there is some code
here http://www.mvps.org/access/api/api0018.htm which you can use to
open any application from a form.

HTH

Peter Hibbs.