1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| Private Sub Transferer_Click()
Dim leSQL As String
leSQL = "INSERT INTO [tbl_reglements_bgt] ( ID_reglement, ID_contrat_fk, [Numero de contrat], Periode, [Compte projet], [Nature_monnaie], Montant_reg, Montant_reg_n, [Total reglements], FE/BIG, [Structure ordonnatrice], Nature_reglement, Num_facture, Date_facture, TVA/RG, [Recu le], [Date recep], [Transmise le], [Date trans], [Doc attache], Fournisseur, MontantDev, ItemDeduction, ID_Projet, DateTransfert ) " & _
"SELECT [tbl_reglements].ID_reglement, [tbl_reglements].ID_contrat_fk, [tbl_reglements].[Numero de contrat], [tbl_reglements].Periode, [tbl_reglements].[Compte projet], [tbl_reglements].Nature_monnaie, [tbl_reglements].Montant_reg, [tbl_reglements].Montant_reg_n, [tbl_reglements].[Total reglements], [tbl_reglements].FE/BIG, [tbl_reglements].[Structure ordonnatrice], [tbl_reglements].Nature_reglement, [tbl_reglements].Num_facture, [tbl_reglements].Date_facture, [tbl_reglements].TVA/RG, [tbl_reglements].[Recu le], [tbl_reglements].[Date recep], [tbl_reglements].[Transmise le], [tbl_reglements].[Date trans], [tbl_reglements].[Doc attache], [tbl_reglements].Fournisseur, [tbl_reglements].MontantDev, [tbl_reglements].ItemDeduction, [tbl_reglements].ID_Projet Date() AS DateTransfert " & _
"FROM [tbl_reglements] " & _
"WHERE (([tbl_reglements].ID_reglement) Not In (select ID_reglement from [tbl_reglement_bgt])) "
DoCmd.SetWarnings False
DoCmd.RunSQL leSQL
DoCmd.SetWarnings True
DoCmd.SetWarnings False
DoCmd.RunSQL leSQL
DoCmd.SetWarnings True
End Sub |
Partager