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 65 66 67 68
| Private Sub Exporter_Click()
Dim base As Database
Dim SQL As String
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Dim strSql As String, extraitD As String, extraitG As String
Dim Valeur As String
Dim test
Set base = Application.CurrentDb
LongueurCh = Right([NumArticle], 4)
Set dbs = CurrentDb
strSql = "SELECT * FROM Commande " _
& " WHERE Selection = True "
Set rst = dbs.OpenRecordset(strSql, dbOpenDynaset)
extraitD = Right(rst.Fields("NumArticle"), 6)
extraitG = Left(rst.Fields("NumArticle"), InStr(rst.Fields("NumArticle"), extraitD) - 1)
test = DLookup("[PoidsTH]", "base", "[Référence] = '" & extraitG & "' ")
CurrentDb.Execute "UPDATE Commande " & _
"SET Commande.PoidsTH = '" & test & "' Where Selection=True ;"
' MsgBox (test)
CurrentDb.Execute "UPDATE Commande " & _
"SET Commande.Ref = '" & extraitG & "' Where Selection=True ;"
CurrentDb.Execute "UPDATE Commande " & _
"SET Commande.Longueur = " & LongueurCh & " Where Selection=True ;"
DoCmd.RunSQL " INSERT INTO EnAttPlanification(NumOrigine,Numero,NumArticle,CodeVariante,DateCommande,DateLivDemander,QteManquante,QteRestante,QtePretDepart,PoidsManquant,Observations,NomDestinataire,NumDestination,Qte,Longueur,Ref,PoidsTH) " & _
"SELECT Commande.NumOrigine, Commande.Numero, Commande.NumArticle, Commande.CodeVariante, Commande.DateCommande, Commande.DateLivDemander, Commande.QteManquante, Commande.QteRestante, Commande.QtePretDepart, Commande.PoidsManquant, Commande.Observations, Commande.NomDestinataire, Commande.NumDestination, Commande.Qte, Commande.Longueur, Commande.Ref, Commande.PoidsTH " & _
"FROM Commande " & _
"WHERE Selection=-1;"
DoCmd.RunSQL " DELETE FROM Commande " & _
" WHERE Selection=-1;"
base.Close
Me.Requery
Me.Refresh
End Sub |
Partager