Print multiple reports from unique ID

[Skip]

I have a report which runs off a table and it works great if I only populate
the table with one part ID. However, this report has grown so popular that I
need to run it for over 300 part numbers and was hoping to do this more
easily. I hope someone can help with the code which would allow me to run a
unique report and save it for each part off the same table.

I hope this make sense since I'm not a great code writer and currently do
this with a nasty macro which is getting very hard to maintain.

 

[kingston via AccessMonster.com]

How is the table populated? Does it contain the part ID? If so, simply add
all of the data for all of the parts and in your report, create a page break
for the part ID group. Otherwise, create a query that includes all of the
data for all part IDs and base your report on the query. None of this
involves any code or macros, but I'm not sure I understood you correctly.

 

[Skip]

Yes, I'm hoping to run the report off one table or query with all of the Part
ID's included. The table is very large 25,000 records and 300 or so Part
ID's. The report is a little complex because it contains .jpgs so I need to
save off the files as separate files because it will be too large to run as
one big report and the images will not come in for all reports.

This is why I think I need code to write not only the Part ID selection but
also saving the file as a unique name before it runs the next Part ID. I can
get some of it to work but not all of it. I hope this helps explain the
issue better.

 

[kingston via AccessMonster.com]

What exactly do you mean by "save off the files as separate files because..."?
Have you tried to print it off as one long report? If so, what errors are
you seeing?

Yes, I'm hoping to run the report off one table or query with all of the Part
ID's included. The table is very large 25,000 records and 300 or so Part
ID's. The report is a little complex because it contains .jpgs so I need to
save off the files as separate files because it will be too large to run as
one big report and the images will not come in for all reports.

This is why I think I need code to write not only the Part ID selection but
also saving the file as a unique name before it runs the next Part ID. I can
get some of it to work but not all of it. I hope this helps explain the
issue better.

How is the table populated? Does it contain the part ID? If so, simply add
all of the data for all of the parts and in your report, create a page break

[quoted text clipped - 10 lines]