Expand|Select|Wrap|Line Numbers
- Dim db As ADODB.Connection
- Set db = New ADODB.Connection
- db.CursorLocation = adUseClient
- db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=F:\Scheduling\AAGTC_Scheduling.mdb;"
- Dim adoprimaryrs1 As ADODB.Recordset
- Set adoprimaryrs1 = New ADODB.Recordset
- Dim strSQL As String
- 'SQL select statement
- strSQL = "SELECT [Avon Park Air Scheduling Post Data].Canceled FROM [Avon Park Air Scheduling Post Data] WHERE Document_ID = " & "'" & Me.txtDocumentID.Text & "'"
- 'Execute the first SQL statement to find conflicts, if any exist
- adoprimaryrs1.Open strSQL, db, adOpenStatic, adLockOptimistic
- If adoprimaryrs1.BOF = False And adoprimaryrs1.EOF = False Then
- If adoprimaryrs1!canceled <> "" Then
- Dim Output1 As String
- Dim Output2 As String
- Dim Output3 As String
- Dim Output4 As String
- Dim Output5 As String
- Dim Output6 As String
- Dim Output7 As String
- Dim Output8 As String
- inputstring = adoprimaryrs1!canceled
- On Error Resume Next
- Output1 = Split(inputstring, " ")(0)
- Output2 = Split(inputstring, " ")(1)
- Output3 = Split(inputstring, " ")(2)
- Output4 = Split(inputstring, " ")(3)
- Output5 = Split(inputstring, " ")(4)
- Output6 = Split(inputstring, " ")(5)
- Output7 = Split(inputstring, " ")(6)
- Output8 = Split(inputstring, " ")(7)
- 'Trap value for Output1
- If Output1 = "Aircraft_1_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft1Cancelled.Value = 1
- End If
- If Output1 = "Aircraft_2_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft2Cancelled.Value = 1
- End If
- If Output1 = "Aircraft_3_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft3Cancelled.Value = 1
- End If
- If Output1 = "Aircraft_4_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft4Cancelled.Value = 1
- End If
- If Output1 = "Aircraft_5_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft5Cancelled.Value = 1
- End If
- If Output1 = "Aircraft_6_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft6Cancelled.Value = 1
- End If
- If Output1 = "Aircraft_7_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft7Cancelled.Value = 1
- End If
- If Output1 = "All_Canceled" Then
- frmEditCompletedFlightMissions.chkCancelEntireEvent.Value = 1
- End If
- 'Trap value for Output2
- If Output2 = "Aircraft_1_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft1Cancelled.Value = 1
- End If
- If Output2 = "Aircraft_2_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft2Cancelled.Value = 1
- End If
- If Output2 = "Aircraft_3_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft3Cancelled.Value = 1
- End If
- If Output2 = "Aircraft_4_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft4Cancelled.Value = 1
- End If
- If Output2 = "Aircraft_5_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft5Cancelled.Value = 1
- End If
- If Output2 = "Aircraft_6_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft6Cancelled.Value = 1
- End If
- If Output2 = "Aircraft_7_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft7Cancelled.Value = 1
- End If
- If Output2 = "All_Canceled" Then
- frmEditCompletedFlightMissions.chkCancelEntireEvent.Value = 1
- End If
- 'Trap value for Output3
- If Output3 = "Aircraft_1_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft1Cancelled.Value = 1
- End If
- If Output3 = "Aircraft_2_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft2Cancelled.Value = 1
- End If
- If Output3 = "Aircraft_3_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft3Cancelled.Value = 1
- End If
- If Output3 = "Aircraft_4_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft4Cancelled.Value = 1
- End If
- If Output3 = "Aircraft_5_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft5Cancelled.Value = 1
- End If
- If Output3 = "Aircraft_6_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft6Cancelled.Value = 1
- End If
- If Output3 = "Aircraft_7_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft7Cancelled.Value = 1
- End If
- If Output3 = "All_Canceled" Then
- frmEditCompletedFlightMissions.chkCancelEntireEvent.Value = 1
- End If
- 'Trap value for Output4
- If Output4 = "Aircraft_1_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft1Cancelled.Value = 1
- End If
- If Output4 = "Aircraft_2_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft2Cancelled.Value = 1
- End If
- If Output4 = "Aircraft_3_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft3Cancelled.Value = 1
- End If
- If Output4 = "Aircraft_4_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft4Cancelled.Value = 1
- End If
- If Output4 = "Aircraft_5_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft5Cancelled.Value = 1
- End If
- If Output4 = "Aircraft_6_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft6Cancelled.Value = 1
- End If
- If Output4 = "Aircraft_7_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft7Cancelled.Value = 1
- End If
- If Output4 = "All_Canceled" Then
- frmEditCompletedFlightMissions.chkCancelEntireEvent.Value = 1
- End If
- 'Trap value for Output5
- If Output5 = "Aircraft_1_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft1Cancelled.Value = 1
- End If
- If Output5 = "Aircraft_2_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft2Cancelled.Value = 1
- End If
- If Output5 = "Aircraft_3_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft3Cancelled.Value = 1
- End If
- If Output5 = "Aircraft_4_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft4Cancelled.Value = 1
- End If
- If Output5 = "Aircraft_5_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft5Cancelled.Value = 1
- End If
- If Output5 = "Aircraft_6_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft6Cancelled.Value = 1
- End If
- If Output5 = "Aircraft_7_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft7Cancelled.Value = 1
- End If
- If Output5 = "All_Canceled" Then
- frmEditCompletedFlightMissions.chkCancelEntireEvent.Value = 1
- End If
- 'Trap value for Output6
- If Output6 = "Aircraft_1_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft1Cancelled.Value = 1
- End If
- If Output6 = "Aircraft_2_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft2Cancelled.Value = 1
- End If
- If Output6 = "Aircraft_3_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft3Cancelled.Value = 1
- End If
- If Output6 = "Aircraft_4_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft4Cancelled.Value = 1
- End If
- If Output6 = "Aircraft_5_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft5Cancelled.Value = 1
- End If
- If Output6 = "Aircraft_6_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft6Cancelled.Value = 1
- End If
- If Output6 = "Aircraft_7_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft7Cancelled.Value = 1
- End If
- If Output6 = "All_Canceled" Then
- frmEditCompletedFlightMissions.chkCancelEntireEvent.Value = 1
- End If
- 'Trap value for Output7
- If Output7 = "Aircraft_1_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft1Cancelled.Value = 1
- End If
- If Output7 = "Aircraft_2_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft2Cancelled.Value = 1
- End If
- If Output7 = "Aircraft_3_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft3Cancelled.Value = 1
- End If
- If Output7 = "Aircraft_4_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft4Cancelled.Value = 1
- End If
- If Output7 = "Aircraft_5_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft5Cancelled.Value = 1
- End If
- If Output7 = "Aircraft_6_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft6Cancelled.Value = 1
- End If
- If Output7 = "Aircraft_7_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft7Cancelled.Value = 1
- End If
- If Output7 = "All_Canceled" Then
- frmEditCompletedFlightMissions.chkCancelEntireEvent.Value = 1
- End If
- 'Trap value for Output8
- If Output8 = "Aircraft_1_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft1Cancelled.Value = 1
- End If
- If Output8 = "Aircraft_2_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft2Cancelled.Value = 1
- End If
- If Output8 = "Aircraft_3_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft3Cancelled.Value = 1
- End If
- If Output8 = "Aircraft_4_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft4Cancelled.Value = 1
- End If
- If Output8 = "Aircraft_5_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft5Cancelled.Value = 1
- End If
- If Output8 = "Aircraft_6_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft6Cancelled.Value = 1
- End If
- If Output8 = "Aircraft_7_Canceled" Then
- frmEditCompletedFlightMissions.chkAircraft7Cancelled.Value = 1
- End If
- If Output8 = "All_Canceled" Then
- frmEditCompletedFlightMissions.chkCancelEntireEvent.Value = 1
- End If
- End If
- If Output1 = "" Then
- frmEditCompletedFlightMissions.chkAircraft1Cancelled.Value = 0
- End If
- If Output2 = "" Then
- frmEditCompletedFlightMissions.chkAircraft2Cancelled.Value = 0
- End If
- If Output3 = "" Then
- frmEditCompletedFlightMissions.chkAircraft3Cancelled.Value = 0
- End If
- If Output4 = "" Then
- frmEditCompletedFlightMissions.chkAircraft4Cancelled.Value = 0
- End If
- If Output5 = "" Then
- frmEditCompletedFlightMissions.chkAircraft5Cancelled.Value = 0
- End If
- If Output6 = "" Then
- frmEditCompletedFlightMissions.chkAircraft6Cancelled.Value = 0
- End If
- If Output7 = "" Then
- frmEditCompletedFlightMissions.chkAircraft7Cancelled.Value = 0
- End If
- If Output8 = "" Then
- frmEditCompletedFlightMissions.chkCancelEntireEvent.Value = 0
- End If
- End If
- Set adoprimaryrs1 = Nothing
- Set db = Nothing