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
| Private Sub Commande189_Click()
Dim code As String
Dim tot As Double
Dim totalchassis As Integer
totalchassis = Me!lign_qte * Me!lign_format.Column(3)
code = forme1(Me!lign_collection, 2) & forme1(Me!lign_format, 2) & forme1(Me!lign_theme, 3)
tot = Me!lign_qte * Me!lign_pu
CurrentProject.Connection.Execute "insert into detailcommandes(codecde_dcde,codetableau_dcde,collection_dcde,theme_dcde,format_dcde,qte_dcde,pu_dcde,devise_dcde,tot_dcde,totchassis_dcde,dcpte_dcde) values ('" & _
Me!code_Commande & "','" & code & "','" & Me!lign_collection & "','" & Me!lign_theme & "','" & Me!lign_format & "','" & Me!lign_qte & "','" & Me!lign_pu & "','" & Me!lign_monnaie & "','" & tot & "','" & totalchassis & "')"
'......
Me.liste_lignecommande.Requery
Me.lign_collection = False
Me.lign_theme = False
Me.lign_format = False
Me!lign_pu = "0"
Me!lign_qte = "1"
End Sub
Private Sub Commande192_Click()
'suppression d'une ligne de commande
CurrentProject.Connection.Execute "delete from detailcommandes where ref_dcde=" & liste_lignecommande.Column(0)
'tble_Détails_cde
Me.liste_lignecommande.Requery
End Sub |
Partager