To in xlsx (Excel +) Format. August 7, DoCmd. OutputTo acOutputQuery, “YourQueryName”, acFormatXLS,, True published app – run this report choosing the export to xls option that the first time. Hello there. Access stdocname = “” DoCmd. OutputTo acReport, “CustomerWorkOrderRpt”, acFormatXLS. I am just trying to save a report to PDF in the specified file. Eventually I am To acFormatPDF, stDocName, TheFile, False, “”.

Author: Dairan Kizragore
Country: Romania
Language: English (Spanish)
Genre: Finance
Published (Last): 26 October 2015
Pages: 58
PDF File Size: 14.19 Mb
ePub File Size: 5.55 Mb
ISBN: 960-2-91457-365-7
Downloads: 26488
Price: Free* [*Free Regsitration Required]
Uploader: Tauramar

However, if the report you want to export is open already in preview acViewPreview when you invoke OutputTothe DoCmd.

Using Criteria In Report Output To Pdf. – UtterAccess Forums

If you want to output the active object, specify the object’s type for the ObjectType argument and leave this argument blank. Use False 0 if you don’t want to start the application. I have the following code: To work around this issue, you can export as XLS format instead. However it seems like the code should work.

DoCmd.OutputTo method (Access)

For example, you can output an Access report with its formatting to a rich-text format document and then open the document in Microsoft Word. You open the report using DoCmd. Docmr, it seems to be a problem to export a report that displays different data sets depending on user input or other factors.


So then I tried to insert a text file into the excel file which worked until I execute a SaveAs and my ribbon disappears again. DeleteObject acTable, “tblTableListing” db.

Close this window and log in. Search this forum only?

ObjectName Optional Variant A string expression that’s the valid name of an object of the type selected dofmd the ObjectType argument. Join your peers stdoocname the Internet’s largest technical computer professional community. Click Here to join Tek-Tips and talk with other members!

Sign in to give feedback. Can anyone see what is wrong with what I have here? A string expression that’s the full name, including the path, of the file you want to output the object to. OutputTothe OutputTo -Method will open the report and export it.

Exactly what I was looking for. If not, then do it and check out FAQ However, with each of the above approaches there comes at least one downside. Always close the hidden report after the PDF file was saved.


Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. I tried a different path and folder to save to and still no luck, getting the same error. Does your code compile? If you leave this argument blank, the default False is assumed. An AcExportQuality constant that specifies the type of output device to optimize for. The default value is acExportQualityPrint. Thanks dhookum – I tried what you suggested but I am still getting the same “Type Ooutputto message.

Wcreport to PDF That did it – it works perfectly now! There is one aspect of using this very convenient method that I frequently see people struggle stdocnaje. Access VBA auto generate mass report by group to Excel. Thank you for helping keep Tek-Tips Forums free from inappropriate posts.

Related Posts