Access 2007 macro Output to command to create pdf files from report.

I have a macro which uses "Output to" command to create pdf file from report.  The report's source is a table with multiple records.  Instead of creating one pdf file, I need multiple files based on PLANID field in the report.  Can this be done with this command.
pbowkerAsked:
Who is Participating?
 
Richard DanekeTrainerCommented:
No, it cannot be with this command.  Output to creates a single PDF file as output.  To create multiple output files you will have to use the Output to multiple times.  
Like create multiple copies of the report.  Each report filtered by a different PLANID field.  Then, in the Macro, use the Output to, PDF option for each of these reports.   The options on the action permit specific naming for each file.  
0
 
Richard DanekeTrainerCommented:
Yes, this can be done with a macro.  
A low tech approach will be to create multiple copies of the report.  Each report filtered by the PLANID field.  Then, in the Macro, use the Output to, PDF option for each of these reports.   The options on the action permit specific naming for each file.  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.