Save a Report from Macro

K

Ken

I am developing a database in Access 97 and will
eventually upload it to a computer running Access in
Office XP. I have a Macro that prints a report containing
several records based on a query. How can I automatically
save the report and print it, not just print it. I know I
can print-preview the report and then physically print and
save it, but I would like to automate it.

Can you include the current date in the name given to the
saved report?

Thank you for your input.
 
S

Steve Schapel

Ken,

I am not 100% sure what you really want to achieve here. There is
really so such thing as "save" a report. Well, there is save the
report's design... but I suspect this is not what you mean, as the
design has presumably already been saved. You can output the report
to a number of file formats, the "native" one being as a Snapshot.
For this, you can use an OutputTo macro action.

- Steve Schapel, Microsoft Access MVP
 

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

Page numbering with Merged Document and IF statements 1
Improving Macro That Keeps First Letter 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
My computer will print from ALL other programs except MS publisher 2007 4
Sending e-mailed reports with macro 1
Report base on a query from a form? 8
.dotm templates not retaining macros 0
Printing reports and a WORD document from a Macro? 0

Top