Si votre email correspond à un compte, vous recevrez un lien de réinitialisation.
sSql = "INSERT INTO tDepenses ( DepenseDate, DepenseFournisseur, DepenseMarchandisesFood,DepenseMarchandisesFoodPrix, DepenseMarchandisesNonFood,DepenseMarchandisesNonFoodPrix, DepenseRemarques) " _& "SELECT DISTINCT #" & Format(PCMDDATE, "mm/dd/yy") & "# AS Expr1," _& "'" & PFOURNISSEUR & "'" & " As Expr2, " _& "'" & UCase(txtFood) & "'" & " As Expr3, " _& Replace(Me.totalFood, ",", ".") & " AS Expr4, " _& "'" & UCase(txtNonFood) & "'" & " As Expr5, " _& Replace(Me.totalNonFood, ",", ".") & " AS Expr6, " _& "'" & PCMDNUM & "'" & " As Expr7 ;"ces deux instructions sont sous le même bouton et aucune donnée n'a été modifiée.
sSql = "INSERT INTO tDepenses ( DepenseDate, DepenseFournisseur, DepenseMarchandisesFood,DepenseMarchandisesFoodPrix, DepenseMarchandisesNonFood,DepenseMarchandisesNonFoodPrix, DepenseRemarques) " _ & "SELECT DISTINCT #" & Format(PCMDDATE, "mm/dd/yy") & "# AS Expr1," _ & "'" & PFOURNISSEUR & "'" & " As Expr2, " _ & "'" & UCase(txtFood) & "'" & " As Expr3, " _ & Replace(Me.totalFood, ",", ".") & " AS Expr4, " _ & "'" & UCase(txtNonFood) & "'" & " As Expr5, " _ & Replace(Me.totalNonFood, ",", ".") & " AS Expr6, " _ & "'" & PCMDNUM & "'" & " As Expr7 ;" ces deux instructions sont sous le même bouton et aucune donnée n'a été modifiée.