Make copy of a Report

  • Thread starter Thread starter QB
  • Start date Start date
Q

QB

How can I make a copy of a report using vba?

Report - Proposal
Copy - Proposal_Bak20090521

Thank you,

QB
 
Figured it out. Here is the solution, should it serve someone else.

DoCmd.CopyObject CurrentDb, "Proposal_bak" & Format(Date, "yyyymmdd"),
acReport, "Proposal"

QB
 
Figured it out. Here is the solution, should it serve someone else.

DoCmd.CopyObject CurrentDb, "Proposal_bak" & Format(Date, "yyyymmdd"),
acReport, "Proposal"

QB
 
Back
Top