Can I automate this in a macro?

[Big Pat]

Hi,

I have a report called rptCurrentInps>20days. Each day I "print" this report, using cutePDFwriter (another great tip from someone on this site) and then I save it in a particular location, always overwriting the previous days version.

The path to the pdf file is W:\Delayed Transfers Of Care\Current Inpatients over 20 days.pdf.

I need to hand this over to another user now, so I want to create a macro that will do all this when a button on a form is clicked, but I'm not sure what to put in the macro.

If I use the OpenReport action, with the Print argument, the report is PHYSICALLY printed from my default printer (and I don't want to make cutePDFwriter the default)

If I use the OpenReport action, with the Print Preview argument, the report displays on screen and I can select the printer, but then I haven't automated it properly and I need it to be a one-click process (or close to it) for the end users who are PC-phobic.

I've also looked at the OutputTo action and selected .rtf format, but this loses quite a bit of formatting, so it not really suitable.

I suspect I need some bespoke code for this, but at this point I'm in over my head. Can anyone help?

Thank you.


PS. Using Access 2003

 

[maxmangion]

how about trying the snapshot format instead of the rtf

DoCmd.OutputTo acOutputReport, "rptName", "Snapshot Format", "Path", True

Also rather than a macro you can place the above code on the onClick event of a command button

 

[Big Pat]

No I'm afraid that wont work, as not all users can open the snapshot format (something to do with the way IT have installed Office2003 I think)

I think I've come across code somewhere that allows you to specify the printer you need e.g.

SetPrinter=cutePDFwriter
Set Path = W:\Delayed Transfers Of Care\Current Inpatients over 20 days.pdf
Save
Overwrite = True

....only written in proper code of course!