1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| Private Sub ProdJValider_Click()
'Dim rSQL As String
'Dim base As Database
'Set base = Application.CurrentDb
'rSQL = " INSERT INTO ProdJour(NumOrigine,Numero,NumArticle,CodeVariante,DateCommande,DateLivDemander,QteRestante,QteManquante,QtePretDepart,PoidsManquant,Observations,NomDestinataire,NumDestination,NumDocExterne,VotreRef,Qte,Poids,Description,CodeMagasin,QteExpe,QteAExpe,NumSemaine,RefCommande,DescriptionCommande,IdLot,Semaine,ReferenceLot,Qteproduite,Consigne Prod,Autres Trait) " & _
' "SELECT EnAttPlanification.NumOrigine, EnAttPlanification.Numero, EnAttPlanification.NumArticle, EnAttPlanification.CodeVariante, EnAttPlanification.DateCommande, EnAttPlanification.DateLivDemander, EnAttPlanification.QteRestante, EnAttPlanification.QteManquante, EnAttPlanification.QtePretDepart, EnAttPlanification.PoidsManquant, EnAttPlanification.Observations, EnAttPlanification.NomDestinataire, EnAttPlanification.NumDestination, EnAttPlanification.NumDocExterne, EnAttPlanification.VotreRef, EnAttPlanification.Qte, EnAttPlanification.Poids, EnAttPlanification.Description, EnAttPlanification.CodeMagasin,EnAttPlanification.QteExpe, EnAttPlanification.QteAExpe, EnAttPlanification.NumSemaine, EnAttPlanification.RefCommande, EnAttPlanification.DescriptionCommande, EnAttPlanification.IdLot, EnAttPlanification.Semaine, EnAttPlanification.ReferenceLot, EnAttPlanification.Qteproduite " & _
' "FROM EnAttPlanification " & _
' "WHERE Choix=-1;"
Forms!F_PlanningLots.SF_DetailLot.Form.Recordset = "INSERT INTO ProdJour(NumOrigine) SELECT EnAttPlanification.NumOrigine FROM EnAttPlanification WHERE Choix = -1 "
Me.Requery
Me.Refresh
End Sub |
Partager