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
|
Set db = OpenDatabase(Application.CurrentProject.Path & "\" & "Base_Compta.mdb")
'===== Calcul du reste_eng sur frm_ENG =====
Set rs = db.OpenRecordset _
("SELECT * FROM Commande, tranche, engagement " & _
"Where xcde_id = cde_id and xtra_id = tra_id and cde_id =" & cde_ID, dbOpenDynaset)
Do While Not rs.EOF
Set rs1 = db.OpenRecordset _
("SELECT * FROM facture WHERE xeng_id =" & rs!Eng_ID, dbOpenDynaset)
VarRest_Eng = 0
Do While Not rs1.EOF
VarRest_Eng = VarRest_Eng + rs1!fct_rgmt
rs1.MoveNext
Loop
Set rs3 = db.OpenRecordset _
("SELECT * FROM Commande, tranche, engagement " & _
"Where xcde_id = cde_id and xtra_id = tra_id and eng_id = " & rs!Eng_ID, dbOpenDynaset)
rs3.Edit
rs3!Eng_Reste = rs!Eng_Mtt - VarRest_Eng
rs3.Update
rs.MoveNext
Loop
'===== Fin calcul du reste_eng sur frm_ENG =====
db.Close |
Partager