Access output report pdf

How can I output a report in PDF format, where the name consists of values from fields? OutputTo command. I am in the process of converting macros in Access databases to VBA code for use in Access The macros open reports which are formatted to go to the Adobe PDF printer using the print command.

The original macro automated this process for 45 consecutive reports. I need to modify or add to the new VBA code so that it automates this process by outputing the file to PDF format without opening the file and prompts the user for the location to save the PDF file. Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. Skip to main content. 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. Any additional feedback? In this article. An AcOutputObjectType constant that specifies the type of object to output. A string expression that's the valid name of an object of the type selected by the ObjectType argument. As they vary in length I thought the best was to export a pdf for each student and then do a batch print.

I've got a query by form setup to grab the individual student report for printing. I just need to find a way to automate the next process I was hoping someone could help me out. I have a copy of the report using the students table the several hundred page one and the individual report uses the following query as its data source.

Then select the next student in the list and repeat the process for the rest of the students. To continue this discussion, please ask a new question. Which of the following retains the information it's storing when the system power is turned off? Submit ».