Kath Pelletti
KP at sdsonline.net
Mon Jul 12 20:16:50 CDT 2004
I need to set up an overnight task in Windows Scheduler, (Win XP Pro) to open an Access database. This is what I have put in the 'Run' line, but I don't get even a flicker from it. "C:\Program Files\Microsoft Office 2000\Office\MSACCESS.EXE" "E:\Sds\Clients\DDTolhurst\IressPricesDatabase\TestBatch.mdb" /cmd AutoRun The TestBatch.mdb has a startup form, with this 'On Open' event: -------------------------------------------------------------------------------- Private Sub Form_Open(Cancel As Integer) If Command$ = "AutoRun" Then MsgBox ("In") ' Call procedure(s) to perform the necessary tasks. 'Call BasProcessItems End If End Sub -------------------------------------------------------------------------------- This one is urgent - any help?? Kath Pelletti Software Design & Solutions Pty Ltd. Ph: 9505-6714 Fax: 9505-6430 KP at SDSOnline.net