Make copy of a Report

Q

QB

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

Report - Proposal
Copy - Proposal_Bak20090521

Thank you,

QB
 
Q

QB

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

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

QB
 
Q

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

Access 2010 Report Button 0
Identify Parameter Source 1
PDF Form Field Values 1
Shortcut to a form 14
Run Make-table query 1
Pass WHERE clause to Sub-Report 1
print report to pdf 2
Name of active tab page 8

Top