Automatic label printing

  • Thread starter jbair via AccessMonster.com
  • Start date
J

jbair via AccessMonster.com

I have a report based on the following query Where I can input an order
number and select the amount of labels I want to print, It works very well,

SELECT [Enter Sales Order] AS [Sales Order], tblCount.CountID
FROM LableTable, tblCount
WHERE (((tblCount.CountID)<=[how many labels do you want?]))

what I want to do is to automatically print those labels and run the query
again for a different order. I work in a production enviroment and need it
to be very quick for the operator so I am trying to avoid hitting the print
button and then opening the query again.. Any ideas? on how to accomplish
that would be greatly appreciated.
Jbair
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top