totn Access

MS Access 2003: Launch Notepad from Access

This MSAccess tutorial explains how to launch Notepad from within Access 2003 (with step-by-step instructions).

Question: How can I launch Notepad 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 Notepad by pasting the following VBA code into your Access database:

Private Sub Command1_Click()

   Call Shell("NOTEPAD.EXE", 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 Notepad.

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 any application from Access.