Private Sub Load_Form()
On Error GoTo ErrorCreating
UpdateDataBase = CreateObjext(XXXXX) 'OLE method to access XXXXX.exe
vbOLEActivateAuto (3)
SendKeys "%(D)", False '"ALT + D", DataBase, pulldown menu
SendKeys "%(U)", False '"ALT + U",Update the database
SendKeys "%(U)", False '"ALT + U",Selects Internet rather than Dial - Up
'program Dial-Up later
While Timer < Now + "00:10.00" 'set up the 10 minute timer
DoEvents 'definately should finish in that time
Wend
SendKeys "%{F4}", True ' Send ALT+F4 to close ' will this also close the pop-up???
ErrorCreating:
If Err.Number = 429 Or Err.Number = 91 Then
'Unable to start or find SF3rdDev
If Err.Number = 429 Then Caption = "Unable to Start, TC2000 Not Registered"
If Err.Number = 91 Then Caption = "Cannot find TC2000 program, Re-Trying"
Else
'Other error ?
Caption = "Error Number " + Err.Number + "ReTry Number = " + ConnectFailure_Count
End If 'May not be a problem, other checks later, do NOT put up a MsgBox
ConnectFailure_Count = ConnectFailure_Count + 1 'initialized on entry to zero
If Err.Number = 91 And ConnectFailure_Count < 3 Then
OpenCloseScheduler ' Try a top down re-start
End If
End Sub