---

MS Access 2003: Launch an application from Access

This MSAccess tutorial explains how to launch an application from within Access using VBA code in Access 2003 (with step-by-step instructions).

Question: How can I launch an application from an Access 2003/XP/2000/97 database?

Answer: From your Access database, you can launch any application that you wish.

For example:

Private Sub Command1_Click()

   Dim stAppName As String

   stAppName = "C:\Program Files\Adobe\Photoshop 6.0\Photoshp.exe"
   Call Shell(stAppName, 1)

End Sub

In this example, we've created a button called Command1. When the user clicks this button, the VBA code will create and open a session of PhotoShop 6.0. Simply set the stAppName variable to the path of the application that you wish to open.

This MSAccess tutorial explains how to launch Microsoft Word from Access.

This MSAccess tutorial explains how to launch Microsoft Excel from Access.

This MSAccess tutorial explains how to launch Notepad from Access.