execute a batch file from command button

[Jacob Mathai]

Can someone please show me how to execute a batch file from ACCESS command button?

 

[jstutz]

Try this...

-----------
Dim str, dimshell

str = "c:\batfile.bat"
dimshell = Shell(str, 1)
-----------

The 1 indicates that the shelled file gets normal focus. Search help for Shell for a full list of options.

js

[This message has been edited by jstutz (edited 10-04-2001).]

 

[Jacob Mathai]

Thanks. It worked