print multiple reports from database

[alecgreen]

Hi

I have a table in my database that contains customer orders, within
those orders are the products reuired to fulfil the order. For each
product there is a related product information guide (in pdf) stored
in a folder on my computer.

Is it possible to run a query/report that prints the requires
information sheets, for each customer order?

(also posted in microsoft.public.access.queries)

Regards

Alec

 

[KARL DEWEY]

Use the Sorting and Grouping to force a new page for each group.

 

[Mark Andrews]

If you are asking about printing the appropriate pdf files for an order?,
it's more like
- loop thru a recordset to get the files that need to be printed and for
each file:
- open acrobat reader or IE and the appropriate file and have it print the
pdf to the printer

You could probably do a search on this last topic to find some code to make
this happen (cince this is the difficult point).

Otherwise store the filename of the information sheet in the database and
just have a simple report showing the filenames.

Mark

 

[Mark Andrews]

This link has some good ideas (if this is what you are trying to do?):
http://www.google.com/search?hl=en&rlz=1T4GGLL_en&q=batch+print+pdf+files&aq=f&oq=&aqi=g2