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
| Public Sub majSousFormulaire()
Dim strSQL As String
strSQL = "select * from R_PlanningLots where true "
strSQL = "SELECT T_Lots.IdLot, T_Lots.NumeroLot, T_Lots.DescriptionLot, T_DetailCommandes.Semaine, T_DetailCommandes.Date, T_DetailCommandes.Poids, Min(DateCommande) AS Debut, Max(DateCommande) AS Fin " & _
"FROM T_DetailCommandes INNER JOIN T_Lots ON T_DetailCommandes.IdLot = T_Lots.IdLot " & _
"WHERE True "
If Nz(Me.DateDebut, "") <> "" Then
strSQL = strSQL & " and DateCommande>= #" & Format(Me.DateDebut, "mm-dd-yyyy") & "#"
End If
If Nz(Me.DateFin, "") <> "" Then
strSQL = strSQL & " and DateCommande<= #" & Format(Me.DateFin, "mm-dd-yyyy") & "#"
End If
strSQL = strSQL & " " & _
"GROUP BY T_Lots.IdLot, T_Lots.NumeroLot, T_Lots.DescriptionLot, T_DetailCommandes.Semaine, T_DetailCommandes.Date, T_DetailCommandes.Poids " & _
"ORDER BY T_Lots.IdLot;"
Me.SF_PlanningLots.Form.RecordSource = strSQL
If Me.SF_PlanningLots.Form.Recordset.RecordCount = 0 Then
Me.SF_DetailLot.Form.RecordSource = "select * from R_LotsCommandes where IdLot=0;"
End If
End Sub |
Partager