I have the same problem as following describe:
"I work for a bank owned by a bank holding corporation with 35+ banks and 280+ branches in 5 states.
With that said, we do have the Acrobat Distiller on our computers. And I'm wondering if it is possible, with VBA, to take the 40+ reports I have to generate from Access each month and print each page of the reports to a separate PDF file? I want to be able to specify the report name and location in the VBA code, rather than typing it in for each page of each report. These reports are sales incentive reports for loan officers, and each page of the reports has a field that contains the officer names. It would be wonderful to be able to use the contents of that field from each page as part of the file name."
Can someone help?! Thanks

I would create a recordset with each officer name - loop thru each name and pass that name (as a variable) to the where clause in the report query. This way you can loop thru each officer name and create a 1 page report for that person. Also set the caption equal to the officer name in the report open event - this will cause the distiller to pick of the caption as the name of the report - forcing a different name for each report.

Any more detail advise? Thank you so much

Create a module called "VarDec" and add

'-----------------VarDec------------------
Option Compare Database
Public OfficerNm As String


On the click event of a command button add
'--------Get distinct officer Names-------
Dim Sql as string
Dim rs as recordset

Sql = "SELECT DISTINCT officerName FROM Table1 ORDER BY officerName"

Set rs = currentdb.openrecordset(Sql)

With rs

.movelast
.movefirst

Do until .eof = true

OfficerNm = !OfficerName
DoCmd.OpenReport "Report1", acViewNormal

.MoveNext
Loop

End with
rs.close


'--------Report Open Event (Report1)--------------
Me.caption = OfficerNm

Me.RecordSource = "SELECT F1, F2 FROM Table1 WHERE OfficerName = '" & OfficerNm &"'"

Set your printer default to the Distiller

Thx, I will try it:D