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
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