MS Access: Launch Microsoft Word from Access 2003/XP/2000/97

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

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

Specifically, you could open a session of Microsoft Word by pasting the following VBA code into your Access database:

Private Sub Command1_Click()

Dim oApp As Object

Set oApp = CreateObject("Word.Application")
oApp.Visible = True

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 Microsoft Word.

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

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

To learn how to launch any application from Access, click here.