Tom
12-06-2006, 10:18 AM
Lately I've been using SQL+ scripts to create base tables to use in Access applications from employee time records because of the massive volume of info. I use batch commands to go through DOS to access the ORACLE server. It was redundant work until I ran across a way to run batch commands from a line of code attached to a button on a VBA form. I hope this helps out someone a little bit.
Option Compare Database
Private Sub Command0_Click()
Call Shell("C:\test.bat", 1)
End Sub
Option Compare Database
Private Sub Command0_Click()
Call Shell("C:\test.bat", 1)
End Sub