Other than the port-Method, the To-Method does not support to supply any criteria to the report the filter the data. If I leave the OutPutFile parameter blank, it brings up the windows save dialogue with the name of the report as the default. If I specify the file. Access VBA auto generate mass report by group to Excel Syntax of DoCmd. OutputTo Method. To(ObjectType, ObjectName.
|Published (Last):||11 June 2007|
|PDF File Size:||6.82 Mb|
|ePub File Size:||19.73 Mb|
|Price:||Free* [*Free Regsitration Required]|
Sunday, February 1, 4: Jeanette Cunningham Replied on April 2, Thanks for marking this as the answer. 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.
Ken, I face new error using temp table. Sorry this didn’t help.
Type True to open the exported fileFalse to docmd.otuputto opening. Can anyone see what is wrong with what I have here? Many thanks in advance.
Email Required, but never shown. Output to PDF Try unscramble your code like: But I also save that report as a text file using the following command. Terms of Reporh Trademarks Privacy Statement. So, it seems to be a problem to export a report that displays different data sets depending on user input or other factors.
And dhookom – I did as you mentioned after researching the importance of Option Explicit I am self-taught and constantly learning even fundamental things. 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.
This argument is ignored for Microsoft Internet Information Server. Try using this DoCmd. I am just trying to save a report to PDF in the specified file.
Which line causes the error? OutputTothe OutputTo -Method will open the report and export it. Luckily there is a very simple solution to the problem that is just not so obvious.