Access: Launch an application from Access 2003/XP/2000/97

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.

To learn how to launch Microsoft Word from Access, click here.

To learn how to launch Microsoft Excel from Access, click here.

To learn how to launch Notepad from Access, click here.