GaryCoulter
Technical User
I have setup a macro using the OenForm and Printout to capture my pivotcharts in a PDF file.
I am trying to find a way to automate this task.
Here are two lines that show what I am trying to do.
DoCmd.OpenForm "Final_Top_PEC_Form",
acFormPivotChart, "", "[id]=1", , acNormal
DoCmd.PrintOut acPrintAll, , , acHigh, 1, True
I would like to know hoiw to create a loop for the [id] going from 1 to 40 and have the printout statement create a unique file for each form.
I am trying to find a way to automate this task.
Here are two lines that show what I am trying to do.
DoCmd.OpenForm "Final_Top_PEC_Form",
acFormPivotChart, "", "[id]=1", , acNormal
DoCmd.PrintOut acPrintAll, , , acHigh, 1, True
I would like to know hoiw to create a loop for the [id] going from 1 to 40 and have the printout statement create a unique file for each form.