either
stAppName = """" & "C:\Program Files\Real\VNC4\vncviewer.exe" & """" &
computername.Value
or
stAppName = """C:\Program Files\Real\VNC4\vncviewer.exe""" &
computername.Value
call Shell(stappname)

Signature
Terry Kreft
>I have the following event proceedure on a command button - which works
> great, however, i would like to add the value of another field onto the
[quoted text clipped - 26 lines]
>
> End Sub
Jason - 07 Dec 2005 13:02 GMT
Thanks very much for that - worked a treat.
thanks for the help
Jason
Tom van Stiphout - 07 Dec 2005 14:11 GMT
The reason Terry's code works is because you have to put double-quotes
around a path that includes funny characters or spaces.
If you had typed your original value in the Run box in Windows, it
wouldn't have worked either: Windows would have thought you wanted to
run a program called:
C:\Program
and pass it a couple of arguments like this:
Files\Real\VNC4\vncviewer.exe
and
<SomeComputerName>
-Tom.
>either
>stAppName = """" & "C:\Program Files\Real\VNC4\vncviewer.exe" & """" &
[quoted text clipped - 4 lines]
>
>call Shell(stappname)