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
|
Dim mt, tm As Integer 'declaration de variable Mt et total Mt
Private Sub Form_Load()
Ouverture 'ouverture du base de données
With E_commande 'chargement du Combo1 Par La Table Commande
Combo1.Clear
If Not .EOF Then .MoveFirst
While Not .EOF
Combo1.AddItem !num_cde
.MoveNext
Wend
End With
With E_client 'chargement du Combo2 et 3 par la table Client
Combo2.Clear: Combo3.Clear
If Not .EOF Then .MoveFirst
While Not .EOF
Combo2.AddItem !compt_clt
Combo3.AddItem !nom_clt
.MoveNext
Wend
End With
With E_article 'chargement du Combo4 et 5 par la table Article
Combo4.Clear: Combo5.Clear
If Not .EOF Then .MoveFirst
While Not .EOF
Combo4.AddItem !code_art
Combo5.AddItem !desig_art
.MoveNext
Wend
End With
ListView1.ListItems.Clear
With ListView1.ColumnHeaders 'Conception L'entête du Listview1
.Add , , "Code Article", (ListView1.Width * (2 / 20)), lvwColumnLeft
.Add , , "Designation", (ListView1.Width * (2 / 22)), lvwColumnLeft
.Add , , "Quantité", (ListView1.Width * (2 / 18)), lvwColumnLeft
.Add , , "Prix Unitaire", (ListView1.Width * (2 / 18)), lvwColumnLeft
.Add , , "Avance", (ListView1.Width * (2 / 18)), lvwColumnLeft
.Add , , "Montant", (ListView1.Width * (2 / 18)), lvwColumnLeft
End With
ListView1.View = 3
End Sub
Private Sub Command1_Click() 'L'ajout Dans Listview
d = Format(DTPicker1, "dd/mm/yyyy")
va = MsgBox("Voulez_vous Vraiment Valider La Commande??", vbYesNo + vbInformation, "VALIDATION")
If va = 6 Then
mt = Val(Text2) * Val(Text1)
tm = tm + mt
Set l = ListView1.ListItems.Add(, , Combo4) 'Code article
l.SubItems(1) = Combo5 'Designation
l.SubItems(2) = Text2 'Quantité
l.SubItems(3) = Text1 'Prix unitaire
l.SubItems(4) = Text3 'Avance
l.SubItems(5) = mt 'Montant
Label13 = tm ' Affichage du Total Montant
Combo4.Text = "": Combo5.Text = "": Text1.Text = "": Text2.Text = ""
Text3.Text = ""
End if
End sub |
Partager