I run the following code from a command button and I have no problem opening
up HSFinancialMgt.mdb. The problem is I want to add
a command line function to this and I don't know how to code it.

Shell """C:\Program Files\Microsoft Office\Office10\MSAccess.exe"" " &
"""c:\HomestayDevelopmentNY\HSFinancialMgt.mdb""", vbNormalFocus

I can put the following code into the run box and have no problem. How can I
get this into my program code?

"C:\Program Files\Microsoft Office\Office10\MSAccess.exe"
"c:\HomestayDevelopmentNY\HSFinancialMgt.mdb" /cmd 12345

I think this is a matter of setting quotations marks, but I tried everything
with no success.
Thanks,
Stan

"Stanley" <(E-Mail Removed)> wrote in message
news:9DBF950C-7F7A-4416-9845-(E-Mail Removed)...
>I run the following code from a command button and I have no problem
>opening
> up HSFinancialMgt.mdb. The problem is I want to add
> a command line function to this and I don't know how to code it.
>
> Shell """C:\Program Files\Microsoft Office\Office10\MSAccess.exe"" " &
> """c:\HomestayDevelopmentNY\HSFinancialMgt.mdb""", vbNormalFocus
>
> I can put the following code into the run box and have no problem. How can
> I
> get this into my program code?
>
> "C:\Program Files\Microsoft Office\Office10\MSAccess.exe"
> "c:\HomestayDevelopmentNY\HSFinancialMgt.mdb" /cmd 12345
>
> I think this is a matter of setting quotations marks, but I tried
> everything
> with no success.


Try:

Shell _
"""C:\Program Files\Microsoft Office\Office10\MSAccess.exe"" " & _
"""c:\HomestayDevelopmentNY\HSFinancialMgt.mdb"" /cmd 12345", _
vbNormalFocus

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)