1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
Private Sub Export_suivi_excel_Click()
Dim qd As QueryDef
Dim sql_chemin
Dim rs_chemin As DAO.Recordset
Dim chemin As String
'DoCmd.DeleteObject acQuery, "Requete_Temporaire"
'id_chemin = 4 --> Feuille suivi
sql_chemin = "SELECT * FROM T_chemin WHERE id_chemin =4 ;"
Set rs_chemin = CurrentDb.OpenRecordset(sql_chemin)
If Not rs_chemin.EOF Then
chemin = rs_chemin("nom_chemin")
Set qd = CurrentDb.CreateQueryDef("Requete_Temporaire", "Select R_Feuille_Suivi_1.numero_bordereau AS N°_BORDEREAU,numero_OT AS N°_OT ,Nom_tech_sly AS DEMANDEUR,Nom_batiment AS BATIMENT,Description AS DESCRIPTIONS,Numero_chantier AS CHANTIER,Avenant AS N°_AVENANT,Date_demande_pose AS DEMANDE_POSE,Date_pose AS POSE,Date_demande_depose AS DEMANDE_DEPOSE,Date_depose AS DEPOSE,Date_facture AS FACTURATION,Somme_cout_total AS MONTANT_INITIAL,Nouveau_montant AS NOUV_MONTANT,Date_rapp_compt AS MOIS_FACTURE_IMAGE,Commentaire AS COMMENTAIRES From R_Feuille_Suivi_2 ORDER BY R_Feuille_Suivi_1.numero_bordereau, avenant ASC")
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "Requete_Temporaire", chemin & "\Feuille_suivi_" & Format(Date, "dd.mm.yyyy") & ".xls"
DoCmd.DeleteObject acQuery, "Requete_Temporaire"
End If
rs_chemin.Close
Set rs_chemin = Nothing
End Sub |
Partager