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 57 58 59 60 61 62 63 64
| sive2 = "SELECT [Parc Z2N].Rame_Complète, defauts_NAT.Date"
sive2 = sive2 & " FROM listing_defauts INNER JOIN (defauts_NAT INNER JOIN [Parc Z2N] ON defauts_NAT.Véhicule = [Parc Z2N].véhicule) ON listing_defauts.Code = defauts_NAT.code_defaut"
sive2 = sive2 & " GROUP BY [Parc Z2N].Rame_Complète, defauts_NAT.Date, defauts_NAT.exploitation, listing_defauts.vrai_defaut"
sive2 = sive2 & " HAVING (((defauts_NAT.Date)<=#" & Now() & "# And (defauts_NAT.Date)>=#" & Now() & "#-3) AND ((defauts_NAT.exploitation)=True) AND ((listing_defauts.vrai_defaut)=True))"
Set rs_sive2 = CurrentDb.OpenRecordset(sive2)
If Not rs_sive2.BOF And Not rs_sive2.EOF Then
rs_sive2.MoveFirst
Do While Not rs_sive2.EOF
DoCmd.RunSQL "insert into test_alerte_Z2N(Rame,[Date Defaut]) values('" & rs_sive2("Rame_Complète").Value & "',#" & Format(rs_sive2("Date").Value, "mm/dd/yyyy") & "#)"
rs_sive2.MoveNext
Loop
Else
End If
engin = "SELECT test_alerte_Z2N.Rame"
engin = engin & " FROM test_alerte_Z2N"
engin = engin & " GROUP BY test_alerte_Z2N.Rame"
Set rs_engin = CurrentDb.OpenRecordset(engin)
If Not rs_engin.EOF Then
rs_engin.MoveLast
n = rs_engin.RecordCount
rs_engin.MoveFirst
Do While Not rs_engin.EOF
nom_fichier = "" ' Ne tenez pas compte de ces lignes, elles concernent la fin de mon code, et pas ce morceau.
nom_fichier2 = ""
nom_fichier3 = ""
nom_fichier4 = ""
rame2 = rs_engin("Rame").Value
sive3 = "SELECT Test_Alerte_Z2N.rame, Test_Alerte_Z2N.[Date defaut], Min(defauts_NAT.Première) AS MinDePremière, defauts_NAT.code_defaut, Sum(defauts_NAT.Occurrences) AS SommeDeOccurrences, listing_defauts.Système, defauts_NAT.localisation, listing_defauts.[Criticité SNCF], [Parc Z2N].Ets_Propriétaire"
sive3 = sive3 & " FROM Test_Alerte_Z2N INNER JOIN (listing_defauts INNER JOIN (defauts_NAT INNER JOIN [Parc Z2N] ON defauts_NAT.Véhicule = [Parc Z2N].véhicule) ON listing_defauts.Code = defauts_NAT.code_defaut) ON (Test_Alerte_Z2N.[Date defaut] = defauts_NAT.Date) AND (Test_Alerte_Z2N.Rame = [Parc Z2N].Rame_Complète)"
sive3 = sive3 & " GROUP BY test_alerte_Z2N.rame , Test_Alerte_Z2N.[Date defaut], defauts_NAT.code_defaut, listing_defauts.Système, defauts_NAT.localisation, listing_defauts.[Criticité SNCF], [Parc Z2N].Ets_Propriétaire"
sive3 = sive3 & " HAVING ((test_alerte_Z2N.rame like '" & rame2 & "') AND (listing_defauts.Système= '" & "SIV ET SAE" & "'))"
Set rs_sive3 = CurrentDb.OpenRecordset(sive3)
If Not rs_sive3.BOF And Not rs_sive3.EOF Then
rs_sive3.MoveFirst
Do While Not rs_sive3.EOF
DoCmd.RunSQL "insert into test_alerte_Z2N_2(Rame,[Date Défaut],[Première heure défaut],Système,[Code défaut],Occurrences, Localisation, Criticité,[Ets Propriétaire]) values('" & rs_sive3("Rame").Value & "',#" & Format(rs_sive3("Date defaut").Value, "mm/dd/yyyy") & "#,#" & Format(rs_sive3("MinDePremière").Value, "hh:mm:ss") & "#,'" & rs_sive3("Système").Value & "','" & rs_sive3("code_defaut").Value & "'," & rs_sive3("SommeDeOccurrences").Value & ",'" & rs_sive3("localisation").Value & "'," & rs_sive3("Criticité SNCF").Value & ",'" & rs_sive3("Ets_propriétaire").Value & "')"
rs_sive3.MoveNext
Loop
Else
End If
'... le code se poursuit, mais c'est le morceau en question ici. |
Partager