ACCESS FEED: RE: [MS_AccessPros] Re: Calling WordPad from Access and file not found

Senin, 19 September 2011

RE: [MS_AccessPros] Re: Calling WordPad from Access and file not found

Thanks Bill, I'm halfway there. Wordpad opened, but the file didn't open. I
copied and pasted your code, and couldn't get the help file to open.

r/David

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Monday, September 19, 2011 10:47 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Calling WordPad from Access and file not found

David

Shell is a curious creature. It does not handle spaces well. Do this
instead, surrounding each string with Chr(34) which is a double-quote:

RetVal = Shell(Chr(34) _
& "C:\Program Files\Windows NT\Accessories\Wordpad.exe " _
& Chr(34) & Chr(34) _
& "C:\Users\David\My Documents\Independent Auto - Help - " _
& "Repair Order.rtf" & Chr(34), 1)

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca

--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "djsdaddy531"
<drtolson@...> wrote:
>
> Great Day, I have created a help file that opens MS WordPad and then I
expect the code to open the help file. I use the following code:
>
>
> Private Sub btnHelp_Click()
>
> On Error GoTo Err_btnHelp_Click
>
> Dim RetVal As Long
> RetVal = Shell("C:\Program Files\Windows NT\Accessories\Wordpad.exe " &
"C:\Users\David\My Documents\Independent Auto - Help - Repair Order.rtf", 1)
>
> Exit_btnHelp_Click:
> Exit Sub
>
> Err_btnHelp_Click:
> MsgBox Err.Description
> Resume Exit_btnHelp_Click
>
>
> End Sub
>
>
> I receive the WordPad error:
>
> C:\Users\David\My
> Cannot fine this file
> Please verify that the correct path and file name are given.
>
> I have checked the path in the code and to the best of understanding, it
appears to be correct. When I open WordPad from the Microsoft Start button,
I can open the file.
>
> Thanks in advance for the assistance.
>
> r/David
>

[Non-text portions of this message have been removed]