Normally you attach code to specific events. For example, if you had a main form in your database that opens when the database is opened, you could attach your code to the On Open or On Load event of the form, and it would run "automatically" when you opened the form. If you wanted this to run on a periodic basis, you could attach this to an On Timer event, but the database would have to be open all the time.
If you need this to run on a host machine, perhaps you can create a scheduled event to run this code, wihtout using Access.
In any event, if you want to run this from VBA, you will need to do something like this (assuming that you have a proper path set for the cmd.bat file):
Code:
Dim objShell as Variant
Dim objExecObject As Variant
Set objShell = WScript.CreateObject("WScript.Shell")
Set objExecObject = objShell.Exec("%comspec% /c CMD.BAT 01-01-000 FROM 00 TO 00")
Did that help?
execute batch file
