Hi vb master i need help on this
here my code:
i need to simplify this code of mine to make it short! i need to code it in a looping statement
I hope you can help me with this.. thank you very much...
here my code:
Code:
If Combo1(0) = rs.Fields("TimeStart") And Combo4(0) = rs.Fields("TimeEnd") And Combo2(0) = rs.Fields("ROOM") And Combo3(0) = rs.Fields("DAYS") Then
cmdSave.Enabled = False
MsgBox ("There's a conflict on this!"), vbCritical
Else
If Combo1(1) = rs.Fields("TimeStart") And Combo4(1) = rs.Fields("TimeEnd") And Combo2(1) = rs.Fields("ROOM") And Combo3(1) = rs.Fields("DAYS") Then
cmdSave.Enabled = False
MsgBox ("There's a conflict on this!"), vbCritical
Else
If Combo1(2) = rs.Fields("TimeStart") And Combo4(2) = rs.Fields("TimeEnd") And Combo2(2) = rs.Fields("ROOM") And Combo3(2) = rs.Fields("DAYS") Then
cmdSave.Enabled = False
MsgBox ("There's a conflict on this!"), vbCritical
Else
If Combo1(3) = rs.Fields("TimeStart") And Combo4(3) = rs.Fields("TimeEnd") And Combo2(3) = rs.Fields("ROOM") And Combo3(3) = rs.Fields("DAYS") Then
cmdSave.Enabled = False
MsgBox ("There's a conflict on this!"), vbCritical
Else
MsgBox (" Good "), vbOKOnly
End If
End If
End If
End If
I hope you can help me with this.. thank you very much...
Comment