Hi - I really appreciate all the assistance this forum provides. Not only in topics I've posted but in browsing through past requests. This is a fantastic resource!
I have a project in which I'm printing reports to PDF (I've purchased Adobe Acrobat)through a macro. The report filters off of a record in a query by:
open form, go to first record, print report (to PDF), go to next record, print report, go to next record, print report, and so on through a loop (there are 15 or so records to loop through).
The problem is that it prompts for "Save As" with each turn. Does anyone know of a way to automate this by saving each report based upon a field within the query (ie "Call this [Field1].pdf").
This may be a tall request but I thought it may be worth a try to pick "the experts'" brains.
Thanks again,
Amy
[This message has been edited by awolf (edited 04-06-2001).]
I have a project in which I'm printing reports to PDF (I've purchased Adobe Acrobat)through a macro. The report filters off of a record in a query by:
open form, go to first record, print report (to PDF), go to next record, print report, go to next record, print report, and so on through a loop (there are 15 or so records to loop through).
The problem is that it prompts for "Save As" with each turn. Does anyone know of a way to automate this by saving each report based upon a field within the query (ie "Call this [Field1].pdf").
This may be a tall request but I thought it may be worth a try to pick "the experts'" brains.
Thanks again,
Amy
[This message has been edited by awolf (edited 04-06-2001).]
