open another application from access

[tracey]

I created a from with a common dialog control. How can I
navigate to a file and open it? Example: I need to open a
file and it has an extetion of ".xls". When I select it,
then the file would open in excel, likewise for any other
file types, ".doc" opens in word, ".pdf" opens in acrobat
and so on.

 

[Allen Browne]

ShellExecute will start the application that is registered to handle that
type of file.

Details:
http://www.mvps.org/access/api/api0018.htm

 

[Bryan Reich [MSFT]]

In VBA try
Application.FollowHyperlink ("<Document Path Here>")