Open any document type from Access 2K2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lukebe - 30 May 2007 06:53 GMT

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

Reply to this Message

Albert D. Kallal - 30 May 2007 08:15 GMT

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

application.FollowHyperlink "path name to document"

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Reply to this Message

Peter Hibbs - 30 May 2007 09:39 GMT

Luke

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

HTH

Peter Hibbs.

>My databases can contain attachments such as PDF, doc, xls, jpg. At
>the moment I just open these within Internet Explorer but I would
[quoted text clipped - 5 lines]
>Thankyou,
>Luke

Reply to this Message