1 2 3 4 5 6
| If Me.Estce_que_léquipement_est_déjà_retourné.Value = True Then
RunMySQL = "INSERT INTO [Arch_Affectation] (Or_Affectation, USER_ID, PIN_Terminal, PIN_SIM, Coque, Vitre, Support_Vehicule, Num_EMEI,Num_SIM, Date_Début, Date_Fin, Date_Fin, Actif, Statut_Affectation, Commentaire, Auteur, Date_Maj, Desc_Action) _
RunMySQL = " VALUES ('" & Me.Or_Affectation & "','" & Me.USER_ID & "','" & Me.PIN_Terminal & "','" & Me.PIN_SIM & "','" & Me.Coque & "','" & Me.Vitre & "','" & Me.Support_Vehicule & "','" & Me.Num_EMEI & "','" & Me.Num_SIM & "',# " & Format(Me.Date_Début, "yyyy/mm/dd") & "#,#" & Format(Me.Date_Fin, "yyyy/mm/dd") & "#,'" & Me.Actif "','" & Me.Statut_Affectation "','" & Me.Commentaire "','" & me.Auteur "','" & me.Date_Maj '","""Remplacement Cause Panne - Materiel Retourné""") _
RunMySQL = RunMySQL & " FROM [Affectation] WHERE [Affectation].EMEI =" & EMEI & ";" _
RunMySQL = RunMySQL & " FROM [Affectation] WHERE [Affectation].EMEI =" & EMEI & ";"
DoCmd.RunSQL RunMySQL |
Partager