1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| Private Sub cmdOk_Click()
Dim SQL As String
Dim STR As String
Dim Main_Total As String
Dim Total_piece As String
Dim Grand_Total As String
Dim Total_Autres1 As String
Dim total_autres2 As String
Dim Total_autres3 As String
StrPoint = "."
StrVirg = ","
Main_Total = Replace(Me.txtMainTotal, StrVirg, StrPoint)
Grand_Total = Replace(Me.txtGrandTotal, StrVirg, StrPoint)
Total_piece = Replace(Me.txtTotalPiece, StrVirg, StrPoint)
Total_Autres1 = Replace(Me.txtAutresPrix1, StrVirg, StrPoint)
total_autres2 = Replace(Me.txtAutresPrix2, StrVirg, StrPoint)
Total_autres3 = Replace(Me.txtAutresPrix3, StrVirg, StrPoint)
SQL = "UPDATE Plaintes SET Tot_main = " & Main_Total & " , Total_Piece = " & Total_piece & " , Total_Autres = " & Total_Autres1 & " , Grand_total = " & Grand_Total & " , Total_autres2 = " & total_autres2 & " , Total_autres3 = " & Total_autres3 & " WHERE Plaintes.[No] = " & Me.txtNo & " "
DoCmd.RunSQL SQL
End Sub |
Partager