Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Access
3rdpartyusrgrp
access
activexcontrol
adp.sqlserver
commandbarsui
conversion
dataaccess.pages
developers.toolkitode
devtoolkits
externaldata
forms
formscoding
gettingstarted
internet
interopoledde
macros
modulescoding
modulesdaovba
modulesdaovba.ado
multiuser
odbcclientsvr
queries
replication
reports
security
setupconfig
tablesdbdesign
  
 
date: Mon, 25 Feb 2008 22:43:01 -0800,    group: microsoft.public.access.conversion        back       


Shell command does not work if target is in folder with spaces   
Hi there,

I recently upgraded from Access 97 to 2003 and noticed the difference in 
syntax when using the shell command. 

However, I also noticed that I can't call any longer a mde application that 
resides in a folder that contains any spaces, as in: C:\Progam Files\

I've done tests and it does work if the folder name doesn't have spaces.
Since my application resides in C:\Program Files\... I've got problems.

Is there a way around it?

Any help is greatly appreciated and thanks a lot in advance...

Cheers
Michael
date: Mon, 25 Feb 2008 22:43:01 -0800   author:   Michael

Re: Shell command does not work if target is in folder with spaces   
Should be fine if you enclose the target in quotes.

Quotes inside quotes need to be doubled up:
    http://allenbrowne.com/casu-17.html

Alternatively, if you don't need to specify the executable (i.e. just use 
the registered software for the file type), you may be able to use 
FollowHyperlink instead of Shell.

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Michael"  wrote in message
news:FDA17D49-6478-4722-BB7D-81F49458115A@microsoft.com...
> Hi there,
>
> I recently upgraded from Access 97 to 2003 and noticed the difference in
> syntax when using the shell command.
>
> However, I also noticed that I can't call any longer a mde application 
> that
> resides in a folder that contains any spaces, as in: C:\Progam Files\
>
> I've done tests and it does work if the folder name doesn't have spaces.
> Since my application resides in C:\Program Files\... I've got problems.
date: Tue, 26 Feb 2008 15:56:14 +0900   author:   Allen Browne lid

Re: Shell command does not work if target is in folder with spaces   
Fantastic Allen, 

thanks for the speedy reply, I'll try it later and I am sure it'll work.

Thanks for the info and have a nice day...
date: Mon, 25 Feb 2008 23:22:01 -0800   author:   Michael

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us