Microsoft KB Archive/325234

= HOW TO: Start Another Application from a Text Box on a Form =

Article ID: 325234

Article Last Modified on 4/6/2006

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q325234





For a Microsoft Access 2000 version of this article, see 209170.

Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

IN THIS TASK
SUMMARY
 * Steps to Start Another Application from a Text Box in Microsoft Access



SUMMARY
This article describes how you can start another application from a text box on a Microsoft Access form. back to the top

Steps to Start Another Application from a Text Box in Microsoft Access
You can start another application from a text box that is on a form by using the Shell Command in Microsoft Visual Basic for Applications (VBA). The following example demonstrates how to start an application and how to load the file whose file name is typed in the text box. This example starts Microsoft Word and then loads the file from the My Documents folder.

Note This example assumes the default installation of Word. Make sure that the command-line command below points to the correct drive and to the folder where Winword.exe is located on your computer. The test document that is used must be present in the My Documents folder.

 Create a new form with two text boxes that are named txtAppPath and txtFilePath .  Put a command button on the form that has the following properties: Name: cmdOpenApp Caption: Open Application   Put the following code on the OnClick event of the button: Private Sub cmdOpenApp_Click Dim str As String str = Chr(34) & Me!txtAppPath & Chr(34) & &quot; &quot; & Chr(34)& Me!txtFilePath & Chr(34) Call Shell(str, 1) End Sub  Save the changes to the form. In the txtAppPath text box, type the complete path to the Microsoft Word 2002 executable as follows:

c:\program files\microsoft office 2000\office10\winword.exe

 In the txtFilePath text box, type the name of the Word document that you want to open.

For example, if there is a file that is named Test.doc that is in your My Documents folder, then you can type Test.doc in the textbox.</li> Open the document in Word 2002.</li></ol>

back to the top

Additional query words: acc2002 howto

Keywords: kbhowtomaster KB325234

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.