Connected2DB Set rs5_Dis = New ADODB.Recordset Set rs5 = New ADODB.Recordset rs5.Open "SELECT * FROM Dispatch ", CN, 1, 2 rs5_Dis.Open "SELECT Distinct Max(Num_Dis) FROM Dispatch ", CN, 1, 2 If rs5.EOF Then Num_Disp.Text = "0001" Dech_Txt(0).Enabled = False Else If rs5_Dis.RecordCount >10 Then Num_Disp.Text = (rs5_Dis(0) + 1) Else MsgBox "le Dernier Dispatching N'as Pas Eté Terminer !!!" Num_Disp.Text = (rs5_Dis(0)) End If End If Num_Disp = Format(Num_Disp, "0000") rs5_Dis.Close Set rs5_Dis = Nothing rs5.Close Set rs5 = Nothing CloseDB
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim Cpt_Dis As Integer Cpt_Dis = 0 Connected2DB Set rs5_Dis = New ADODB.Recordset rs5_Dis.Open "SELECT distinct Num_Dis FROM Dispatch group by Num_Dis", CN, 1, 2 If rs5_Dis.EOF Then Num_Disp.Text = "0001" Dech_Txt(0).Enabled = False Else Cpt_Dis = rs5_Dis.RecordCount Do While Not rs5_Dis.EOF If Cpt_Dis > 10 Then Num_Disp.Text = (rs5_Dis(0) + 1) Else MsgBox "le Dernier Dispatching N'as Pas Eté Terminer !!!" Num_Disp.Text = (rs5_Dis(0)) Dispa_MS_Refresh End If rs5_Dis.MoveNext Loop End If Num_Disp = Format(Num_Disp, "0000") rs5_Dis.Close Set rs5_Dis = Nothing CloseDB
Else rs5_Dis.MoveLast Nb=rs5_Dis.RecordCount rs5_Dis.MoveFirst If Nb >10 Then Num_Disp.Text = (rs5_Dis(0) + 1) Else MsgBox "le Dernier Dispatching N'a Pas Eté Terminé !!!" Num_Disp.Text = (rs5_Dis(0)) End If End If