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
|
Private Sub InsertFAE(ByVal fCodeSociete As String, fCodeJournal As String, fDateArrete As Date, fCompte As String, fRubrique As String, fTxTVA As Double, fNumCompteTVA As String, fNumCompteCollectif As String, ByVal fLibelleEcriture As String, fHT As Double, fTVA As Double, fTTC As Double, fNumPieceInterne As String, fRubrique As String)
Dim LrqtInsertFAEd As String 'première partie de la requete SQL
Dim LrqtInsertFAEf As String 'deuxième partie de la requete SQL
'première partie de la requete
LrqtInsertFAEd = "INSERT INTO T_FAESAGE(CodeScte,CodeJournal,DatePiece,"
LrqtInsertFAEd = LrqtInsertFAEd + "CompteCG,RubriqueAnalytique,TauxTVA,CmpteTVA,CmpteCollectif,LibelleEcriture,"
LrqtInsertFAEd = LrqtInsertFAEd + "MontantProduit,MontantTVA,MontantCollectif,NumPieceInterne,SAProduit)"
LrqtInsertFAEd = LrqtInsertFAEd + " VALUES ('" + fCodeSociete + "',"
LrqtInsertFAEd = LrqtInsertFAEd + "'" + fCodeJournal + "',"
LrqtInsertFAEd = LrqtInsertFAEd + "#" + StrConv(fDateArrete, 1) + "#,"
LrqtInsertFAEd = LrqtInsertFAEd + "'" + fCompte + "',"
LrqtInsertFAEd = LrqtInsertFAEd + "'" + fRubrique + "',"
LrqtInsertFAEd = LrqtInsertFAEd + ConvDecVirgulePoint(fTxTVA) + ","
'deuxième partie de la requete
LrqtInsertFAEf = "'" + fNumCompteTVA + "',"
LrqtInsertFAEf = LrqtInsertFAEf + "'" + fNumCompteCollectif + "',"
LrqtInsertFAEf = LrqtInsertFAEf + "'" + fLlibelleEcriture + "',"
LrqtInsertFAEf = LrqtInsertFAEf + ConvDecVirgulePoint(fHT) + ","
LrqtInsertFAEf = LrqtInsertFAEf + ConvDecVirgulePoint(fTVA) + ","
LrqtInsertFAEf = LrqtInsertFAEf + ConvDecVirgulePoint(fTTC) + ","
LrqtInsertFAEf = LrqtInsertFAEf + "'" + fNumPieceInterne + "',"
LrqtInsertFAEf = LrqtInsertFAEf + "'" + fRubrique
LrqtInsertFAEf = LrqtInsertFAEf + "');"
DoCmd.RunSQL (LrqtInsertFAEd + LrqtInsertFAEf) 'éxécution de la requete
End Sub |
Partager