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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Identify Parameter Source 1
Access 2010 Report Button 0
PDF Form Field Values 1
Shortcut to a form 14
Run Make-table query 1
Name of active tab page 8
RUntime crashing 3
intercept delete action 1

Back
Top