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.

Author: Goltigor Zulukus
Country: Rwanda
Language: English (Spanish)
Genre: Marketing
Published (Last): 22 October 2009
Pages: 169
PDF File Size: 4.78 Mb
ePub File Size: 1.51 Mb
ISBN: 632-7-48875-358-7
Downloads: 69493
Price: Free* [*Free Regsitration Required]
Uploader: Grokus

An AcFormat constant that specifies the output format. Email Required, but never shown. Let’s try whether a different filename or path allows it to work.

I suggest you to add another code to open pdf after export. The following works for me: When i go to that location ” C: I have an excel template with a custom ribbon with buttons for preset sorts and filters.

DoCmd.OutputTo method (Access)

You may also use DoCmd. Login Login with facebook. If you want to output the active object, specify the object’s type for the ObjectType argument and leave this argument acoutputrepory.

The Access data is output in the selected format and can be read by any application that uses the same format. An Acoutputrepotr constant that specifies the type of output device to optimize for. By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.


OutputFile Optional Variant A string expression that’s the full name, including the path, of the file you want to output the object to. You will want to check to make sure the folder exists first, and create it if it doesn’t exist. If you leave this argument blank, Access outputs the data by using the Windows default encoding for text files and the default system encoding for HTML files.

That strongly suggests that, for some reason, Access can’t write to the specific folder path on C: If you leave this argument blank, Access prompts you for acoutpuutreport output file name.

Stack Overflow works best with JavaScript enabled. Dirk Goldgar Replied on March 2, For example something like: 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.

First of all thanks for helping me out I got it to work!!! Tell us about your experience with our site.


Are you running Access as some other user? The type of character encoding format you want used to output the text or HTML data.

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?

access , To acOutputReport Problem – Microsoft Community

The OutputTo action was canceled. This line looks wrong: The result I get is “S: Sorry this didn’t help. This argument is ignored for Microsoft Internet Information Server. TransferSpreadsheet Method has other functions other than exporting, such as import files and exporting to an Excel template. 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.