View Full Version : AcViewPreview for Previewing a Report- but what about print?


harleyskater
05-07-2008, 04:56 AM
Ok I think I have a simple question but I am having trouble tracking this answer down myself. If "DoCmd.OpenReport "report",acViewPreview,,,"
opens a report in print preview, what code do you use to just print the report without the preview "DoCmd.OpenReport "report", acPrint,,,," is not working :)

I am using Access 2007. : ) thank you!

harleyskater
05-07-2008, 04:58 AM
I found an answer

"DoCmd.OpenReport "report",,,,"

Ok I think I have a simple question but I am having trouble tracking this answer down myself. If "DoCmd.OpenReport "report",acViewPreview,,,"
opens a report in print preview, what code do you use to just print the report without the preview "DoCmd.OpenReport "report", acPrint,,,," is not working :)

I am using Access 2007. : ) thank you!

harleyskater
05-07-2008, 11:58 AM
same question but with printing to pdf or emailing with pdf attachment in Access 2007 :)

harleyskater
05-19-2008, 06:32 AM
Just checking up one more time, does anyone know a vba command to send the report to a pdf? I am using access 2007 :)

same question but with printing to pdf or emailing with pdf attachment in Access 2007 :)