RunApp function in Macro

[tbd]

I am trying to use the above function in a Macro.
Basically I want the Macro to open up another Access
Database, but my Command Line code is not working. At the
minute, I am doing the following in the command line:

Access.exe C:\Test\OptionsTakeup.mdb

I've came to the conclusion this is obviously wrong, so
what should I be doing?

Thanks in advance!

TBD

 

[Ken Snell [MVP]]

You need to provide the full path to the msaccess.exe program in the first
part of the command line. Enclose the path in "" characters if there are
blanks in the any part of the path..

 

[tbd]

Thanks Ken, I knew I was doing something stupid!

-----Original Message-----
You need to provide the full path to the msaccess.exe program in the first
part of the command line. Enclose the path in "" characters if there are
blanks in the any part of the path..

--

Ken Snell
<MS ACCESS MVP>




.

 

[John B]

I too am having a problem with Runapp from a macro. I
want to open a mailmerged document but it doesn't work.
It won't run an application from a command button either.
I'm using access 2000 and windows xp there may be a bug?