Old , AM. ions. Access User. Join Date: May Posts: Thanks: 8. Thanked 10 Times in 9 Posts. ions is an unknown quantity at this. This Access tutorial explains how to use DoCmd. acOutputReport, 3, Report I’m having a bit of trouble with VBA in MS Access My code OutputTo acOutputReport, “”, acFormatPDF, mypath & MyFileName DoCmd.

In the code below, I keep getting an error in the line with the DoCmd.

When i change it to “D: Acoutpurteport that doesn’t work, try changing the folder path to your Documents folder to which we know you have full permissions. This thread is locked. First of all thanks for helping me out Here’s the specific error: Sign up or log in Sign up using Google. This site in other languages x. However, all of these assume creation of a new file. OutputFile Optional Variant A string expression that’s the full name, including the path, of the file you want to output the object acceds.

In that video, everything does look correct.

Can anyone help me pls!!! The default value is acExportQualityPrint. OurputTo line, and check the value of filepath at that point. Dirk Goldgar Replied on March 3, Close acReport, “Settlement Report” rs. The OutputTo action was canceled. Is there somekind of bug in access for saving a report acouptutreport a specific place with a specific name on a harddrive?

When i remove “filepath” at the end of the DoCmd. If so, I could imagine that you might be running into permissions issues. I suspect it’s not valid. If you leave this argument blank, the default False is assumed. If you created the folder, you should certainly have permission to save to it.

Thanks for marking this as the answer. You may also leave feedback directly on GitHub. There are no open issues.

If you run Visual Basic code containing the OutputTo method in a library database, Microsoft Office Access searches for the object with this name, first in the library database, then in the current database. Datum If that really is your code, I don’t think Filename gets a valid value.

DoCmd.OutputTo method (Access)

Click here for instructions on how to enable JavaScript in your browser. Remarks You can use the OutputTo method to output the data in the specified Access database object a datasheet, form, report, module, data access page to several output formats. Jan, I have just updated another thread to include information how to export to excel template, see below http: I’m wondering if it’s not working because the “” folder isn’t created yet.

Type True to open the exported fileFalse to disable opening.

Did you try setting a breakpoint, as I said earlier, and examining the value of filepath to make sure that it’s a valid filename? Try setting a breakpoint in the code, on the DoCms. By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.

I’m then exporting that report to a folder that’s created with today’s date and the PDF file is assigned a name with the Settlement No.

To method (Access) | Microsoft Docs

When i remove “filepath” from the end off the DoCmd Example The following code example outputs the Employees table in rich-text format. TransferSpreadSheet Method to export different objects to specific file types, for example, export Query to xlsx.

Your email address will not be published. Did this solve your problem? This argument is ignored for Microsoft Internet Information Server. Access VBA auto generate mass report by group to Excel. You can follow the question or vote as helpful, but you cannot reply to this thread.

A string expression that’s the valid name of an object of the type selected by the ObjectType argument. If you omit this argument, Access prompts you for the output format. The default value is acExportQualityPrint. You may also use DoCmd. Yes, the folder has to exist. Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.

Tell us about your experience with our site. Let’s try whether a different filename or path allows it to work.