Export a Report to a .Tiff image via VBA

[mlr0911]

Hello all....is there a way to output a report to a .tiff image in access?

The snapshot format that microsoft offers isn't compatiable with our program that we upload reports to...only tiff images.

Thanks for your help.

 

[gemma-the-husky]

pdf's any good?

that is more common, and there are lots of solutions available

 

[mlr0911]

gemma-the-husky

Yes, PDF's are an option....though I don't know how to apply it to my access report.

Thanks for your help.

 

[mlr0911]

Is there an option for PDF for Access 2003?

 

[DCrake]

Not in 2003 but 2007 has. Having said that there are some shareware products out there that can be used in 2003. Someone mentioned CutePDF to me. Could try that.

David

 

[mlr0911]

I've acquired 2007 (our company uses different versions) and when I code the Outputto event, I'm getting the following error

Run-Time Error '2585'
This action can't be carried out while processing a form or report event.

I want to have the code execute on the "Open" event of my report.

Here is the code I'm using:

DoCmd.OutputTo acOutputReport, "quality", acFormatPDF, "C:\Test.PDF", False

What am I missing?

Thanks for your help and suggestions.

 

[DCrake]

You cannot do this in the open event of the form. What you can do is to remove the open report command and replace it with the out to command and change the last false to to True. This will generate a pdf file then open it in preview format.

David