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
| Public Sub MiseAjour_Tbl_HistoVrac()
With Me.Liste_VracTerminee
strSQLSELECT = "SELECT Date() As jour,tb_Liaison.No_Liaison, tb_ProvDest.Nom_Ville,tb_Remorque.No_remorque,tb_Liaison.Heure_Theo, tb_TypeLiaison.Type," & _
"tb_FrequenceLiaison.Frequence,tb_Liaison.Commentaires,tb_Liaison.Heure_Arrivee,tb_Liaison.Heure_MiseAquai, tb_Liaison.NbQuai," & _
"tb_Liaison.NbColis, tb_Liaison.Immat,tb_Liaison.Heure_FinDechargement,tb_Liaison.SelectionArrivee,tb_Liaison.SelectionMiseAQuai,tb_Liaison.SelectionTerminee"
strSQLFROM = "FROM tb_FrequenceLiaison INNER JOIN (tb_ProvDest INNER JOIN(tb_TypeLiaison INNER JOIN(tb_Remorque INNER JOIN tb_Liaison ON" & _
" tb_Remorque.id_remorque=tb_Liaison.No_Remorque)ON tb_TypeLiaison.id_TypeLiaison=tb_Liaison.Mvt_Type)ON tb_ProvDest.id_ProvDest=tb_Liaison.Prov_Dest)" & _
"ON tb_FrequenceLiaison.id_TypeFrequence=tb_Liaison.Freq_Type"
strSQLWHERE = "WHERE SelectionArrivee AND SelectionMiseAQuai AND SelectionTerminee"
strSQLORDERBY = "ORDER BY tbl_HistoVrac.Heure_Arrivee;"
txt_ChaineSQL_Vrac_Terminee = strSQLSELECT & vbCrLf & _
strSQLFROM & vbCrLf & _
strORDERBY & vbCrLf & _
strSQLWHERE
'CREATION DE LA REQUETE MISE A JOUR
strInsert = "INSERT INTO tbl_HistoVrac(jour,No_Liaison, Nom_Ville, No_remorque, Heure_Theo, Type, Frequence,Commentaires,Heure_Arrivee,Heure_MiseAquai," & _
"NbQuai,NbColis,Immat,Heure_FinDechargement,SelectionArrivee,SelectionMiseAQuai,SelectionTerminee) " & txt_ChaineSQL_Vrac_Terminee
CurrentDb.Execute strInsert
.Requery
End With
End Sub |
Partager