Pausing between report sections.

  • Thread starter Thread starter Terry DeJournett
  • Start date Start date
T

Terry DeJournett

Does anyone know if this can be done?

I have a report that prints "Labels". The labels show Item number,
description and date. The report is based on a query that pulls from a
table all records that match todays date. It could be 5 items our it could
be 100 items. Each item could have 5 labels printed or as many as 300
labels printed.

I have a form set up that runs this query and prints the report out. The
problem is that it prints ALL the labels in one group. These labels are
printed on a high speed label printer.

What I want to accomplish is that the report print the first item (1 to 300
labels) than pause with a message box something like "Do you want to
continue?" then after hitting OK that it print the next item with the
appropriate amount of labels, then pause again, etc.

Here is the SQL code for my query:
SELECT ProduceInventoryPickTableREVISED.ItemNumberDetail,
ProduceInventoryPickTableREVISED.ItemName, [Please Enter Code Date] AS
CodeDate, ProduceInventoryPickTableREVISED.[Revised QTY], tblCount.CountID
FROM ProduceInventoryPickTableREVISED, tblCount
WHERE (((ProduceInventoryPickTableREVISED.ItemNumberDetail) Like "*710*")
AND ((tblCount.CountID)<=[Revised Qty]));

Thanks for any advise or assistance.

Terry
 
Terry:

This is pretty simple to do. Add a grouping based on the item number or
another logical group where the labels should break; add a group footer;
sizing it to 0 on the report. Then in the On Print event of the group
footer add a little code like this:

MsgBox "Hey, pick up the last groups labels from the printer, they are
done.", 64, "Click OK to continue the next group"

That should do it.
 
Back
Top