By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,395 Members | 1,460 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,395 IT Pros & Developers. It's quick & easy.

How to run commands from access

P: n/a
I would like to be able to run a few applications with a command line switch
as if you were running it from a shortcut.
Sort of like a bat file but I need to be able to run the files with the long
names and with spaces.

like this

c:\files\launche.exe /r /p c:\mylaunchfiles\launch file 1
c:\files\launche.exe c:\mylaunchfiles\launch file 2
c:\files\launche.exe c:\mylaunchfiles\launch file 3

How can I do this in access to accomodate these long file names and with
switches.

Thanks in advance

Danny


Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use the Shell command & put double-quotes around the command line.
E.g.:

Const Q = """" - 1 double-quote
dim strCmd As string

strCmd = Q & "c:\files\launche.exe c:\mylaunchfiles\launch file 2" & Q

Shell strCmd
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQEZZi4echKqOuFEgEQLPsACfa7Sv5zm4wTn4MFXShpIXYO vDF5oAn0Lj
Z4TIMQZK+BhTUYsH3+6WJ5vi
=rYfo
-----END PGP SIGNATURE-----
Danny wrote:
I would like to be able to run a few applications with a command line switch
as if you were running it from a shortcut.
Sort of like a bat file but I need to be able to run the files with the long
names and with spaces.

like this

c:\files\launche.exe /r /p c:\mylaunchfiles\launch file 1
c:\files\launche.exe c:\mylaunchfiles\launch file 2
c:\files\launche.exe c:\mylaunchfiles\launch file 3

How can I do this in access to accomodate these long file names and with
switches.


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.