Open any document type from Access 2K2

[lukebe]

My databases can contain attachments such as PDF, doc, xls, jpg. At
the moment I just open these within Internet Explorer but I would
really prefer to open them in the associated application directly.
I could have a big IF block to create an instance of the application
with VBA but surely there is a better way.
I'm comfortable with API calls, etc so any method is appreciated.

Thankyou,
Luke

 

[Albert D. Kallal]

To launch any document from ms-access, simply go:

application.FollowHyperlink "path name to document"

 

[Peter Hibbs]

Luke

You can also use the ShellExecute function, see
http://www.mvps.org/access/api/api0018.htm
for details.

HTH

Peter Hibbs.