1 2 3 4 5 6 7 8 9 10 11 12 13
| Dim RunMySQL As String
Dim VrEMEI As Integer '(j'ai essayer avec : string, long, integer long sa ne fonctionne pas)
Dim VrSIM As Integer
Dim VrUSER_ID As String
USER_ID = Me.Recherche_Employé
VrEMEI = Me.Liste_Equipement ' (15 chiffre)
VrSIM = Me.Liste_Abonnemen ' (13chiffre)
RunMySQL = "INSERT INTO [Affectation] ( Or_Affectation, USER_ID, PIN_Terminal, PIN_SIM, Coque, Vitre, Support_Vehicule, Num_EMEI, Num_SIM, Date_Début, Date_Fin, Actif, Statut_Affectation, Commentaire)"
RunMySQL = RunMySQL & " select Or_Affectation ,""" & VrUSER_ID & """, PIN_Terminal, PIN_SIM, Coque, Vitre, Support_Vehicule, " & VrNum_EMEI & " ," & VrNum_SIM & ", Date_Début, Date_Fin, Actif, Statut_Affectation, Commentaire"
DoCmd.RunSQL RunMySQL |
Partager