1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
| Private Sub DATE_AfterUpdate()
Dim rs1 As DAO.Recordset
Dim rs2 As DAO.Recordset
Dim rs3 As DAO.Recordset
Dim rs4 As DAO.Recordset
Dim db As DAO.Database
Set db = CurrentDb()
Set rs1 = db.OpenRecordset("SELECT COMMANDES.NUMERO, COMMANDES.DATE, COMMANDES.NUMCOMM, Day([DATE]) AS JOUR, Month([DATE]) AS MOIS FROM COMMANDES WHERE (((Day([DATE]))=24) AND ((Month([DATE]))=12))")
Set rs2 = db.OpenRecordset("SELECT COMMANDES.NUMERO, COMMANDES.DATE, COMMANDES.NUMCOMM, Day([DATE]) AS JOUR, Month([DATE]) AS MOIS FROM COMMANDES WHERE (((Day([DATE]))=25) AND ((Month([DATE]))=12))")
Set rs3 = db.OpenRecordset("SELECT COMMANDES.NUMERO, COMMANDES.DATE, COMMANDES.NUMCOMM, Day([DATE]) AS JOUR, Month([DATE]) AS MOIS FROM COMMANDES WHERE (((Day([DATE]))=31) AND ((Month([DATE]))=12))")
Set rs4 = db.OpenRecordset("SELECT COMMANDES.NUMERO, COMMANDES.DATE, COMMANDES.NUMCOMM, Day([DATE]) AS JOUR, Month([DATE]) AS MOIS FROM COMMANDES WHERE (((Day([DATE]))=01) AND ((Month([DATE]))=01))")
If Day(Me.DATE) = 24 And Month(Me.DATE) = 12 Then
If rs1.EOF Then
Me!NUMCOMM = 1
Else
rs1.MoveLast
Me!NUMCOMM = rs1!NUMCOMM + 1
End If
ElseIf Day(Me.DATE) = 25 And Month(Me.DATE) = 12 Then
If rs2.EOF Then
Me!NUMCOMM = 1
Else
rs2.MoveLast
Me!NUMCOMM = rs2!NUMCOMM + 1
End If
ElseIf Day(Me.DATE) = 31 And Month(Me.DATE) = 12 Then
If rs3.EOF Then
Me!NUMCOMM = 1
Else
rs3.MoveLast
Me!NUMCOMM = rs3!NUMCOMM + 1
End If
ElseIf Day(Me.DATE) = 1 And Month(Me.DATE) = 1 Then
If rs4.EOF Then
Me!NUMCOMM = 1
Else
rs4.MoveLast
Me!NUMCOMM = rs4!NUMCOMM + 1
End If
Else
Me!NUMCOMM = ""
End If
rs1.Close
rs2.Close
rs3.Close
rs4.Close
Set rs1 = Nothing
Set rs2 = Nothing
Set rs3 = Nothing
Set rs4 = Nothing
Set db = Nothing
End Sub |
Partager