ACCESS FEED: [MS_AccessPros] How do I open a file in WordPad from a command button

Rabu, 19 Oktober 2011

[MS_AccessPros] How do I open a file in WordPad from a command button

Great Day, I am creating helps files in WordPad. When I attempt to open the file with the command button, I get the following WordPad error:

C:\Users\David\Documents\IndependedntAutoHelpRepairOrder.rtf
Cannot find this file
Please verify that the correct path and file name are given.

This is the code that I use to try to open the file:

Dim RetVal As String
RetVal = Shell("C:\Program Files\Windows NT\Accessories\Wordpad.exe " & "C:\Users\David\Documents\IndependentAutoHelpRepairOrder.rtf", 1)

I have been having difficulty locating the proper path name of the file, so I went to the windows explorer dialogue box and highlighted the file and held down the shift key while right clicking the mouse, and then I clicked "Copy as Path". I pasted the path directly to the code.

I am using Access 2007 and saving the files in 2003 version, and I've got Windows 7 and Office 7 if that helps.

Thanks in advance,

David