Ms access open report as pdf

THX for the code. I want every distinct pdf to have a specific name ex. The solution I came up with is DoCmd. Second question: I would like to store the pdf in a SQL-database. Anybody who has experience with this? Close acReport, reportName, acSaveNo. Your email address will not be published. Skip to main content. Looking For Assistance or Customizations? This browser is no longer supported. Download Microsoft Edge More info.

Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. DefaultPrintername oPrinterSettings. SetValue "Output", sFileName. SetValue "ConfirmOverwrite", "no". SetValue "ShowSettings", "never". PrintOut End Sub. Variables "AccountNo". Was this reply helpful? Yes No. Sorry this didn't help. Thanks for your feedback. I guess this is a code for Word.

But you showed me the right direction and i finally figured it out. But that's fine with me. Good code has it's price. BUT now i got another problem and maybe you had the same: My Report has orientation landscape. If i print it to Pdf with Bullzip manually i get the correct result. If i do it via VB with Bullzip it's always portrait. Even if i set 'orientation' to 'landscape' the result is still the same ie wrong orientation Did you have the same problem and did you find a solution?

So I would try the acExportQualityPrint option - it could well resolve your issue without any 3rd party tools. Hi, I have created a report in access using multiple forms which derive the required information for me from the tables. Any help is greatly appreciated. Tuesday, April 2, PM. Hi asdw, Suppose that there is a form bounding to a table contains the ID field. Recordset rs. MoveFirst Do While Not rs. Fields "ID". Close acReport, sReportName rs. Marked as answer by asdw Thursday, April 4, AM.

Thursday, April 4, AM. You'll find an example as InvoicePDF. GoToRecord acForm, Me.