Thanks for any help.. I currently have a database with about 100
products with picture links in an external folder. I have a form from
which I can successfully display a product, its specifications, and
print a sheet with the picture and the relative data. I'm trying to
write some code to allow me to bring up the products and add them to a
batch of about 20 different product sheets to print at one time, rather
than the user having to hit the print button 20 times after, that is
print a product sheet, then bring up another and hit print again, etc.
I need to accumulate a batch of sheets to print. Is there a way to do
this.. maybe code to place each product and its picture-filepath into a
temporary table then print all found in the temporary table? Thanks!
Dav

Parasyke wrote:

Thanks for any help.. I currently have a database with about 100
products with picture links in an external folder. I have a form from
which I can successfully display a product, its specifications, and
print a sheet with the picture and the relative data. I'm trying to
write some code to allow me to bring up the products and add them to a
batch of about 20 different product sheets to print at one time, rather
than the user having to hit the print button 20 times after, that is
print a product sheet, then bring up another and hit print again, etc.
I need to accumulate a batch of sheets to print. Is there a way to do
this.. maybe code to place each product and its picture-filepath into a
temporary table then print all found in the temporary table? Thanks!
Dav

++++++++++++++++++
I have in the past created a print table (created on startup with all
the products ID's in it and an empty flag field to tick off for
printing (code this to alternate between on and off in an on-click
procedure), that way you can print sheets where the print this flag is
set to true by basing your report on a query that includes your data
joined on ProductID and where the print flag is set to on!
++++++++++++++++++