Script/VBA, other possible solution to automating report bursting and copy to folder/directories?

[thorNotFromNorway]

Hello All,
This is my first post here.

Is there a way in Access VBA (or any other way (really)) to split Access Reports (by group change) into individual reports and send them to a directory based on the group? In other words, if I have a report for each professor within the report and I want to split into separate say, PDFs -one for each prof-, and then automate sending them to the directory with the same name as the professor (one folder/directory for each professor), can I do this with a script?
I've tried searching but I may not have the right keywords. For one thing, when I say "Microsoft Access": and "split" I get results on how to split the Access database into a front and back end. Not what I'm looking for at all. One of the dozens of PDF splitting software products could split the PDFs but not send them to folders. Besides, it would be great to have a scripting solution if possible.
Thanks!

 

[alansidman]

Firstly, you will need to filter your report: Look at this video on how to do that

Macromedia Flash (SWF) Movie Created by Camtasia Studio 2

then you will need some script to save it as a PDF. Look at this link

Access 2007 - "Save as PDF" from VBA / automation

 

[thorNotFromNorway]

Firstly, you will need to filter your report: Look at this video on how to do that

Macromedia Flash (SWF) Movie Created by Camtasia Studio 2

then you will need some script to save it as a PDF. Look at this link

Access 2007 - "Save as PDF" from VBA / automation

Thank you alansidman! Do you know how I could automate (loop through) all the choices in the list as if a human was choosing Each category and generating Report one_by-one? We have hundreds to do. I usually don't code in VBA but I'm trying to help out a coworker who is doing this by hand. He's generating each one at a time and turning it into a PDF. Then he puts Each one into a separate directory. takes him days. Thanks again.