R
Rob Ventura
Guest
Hello,
I am trying to set up an Access database to print up labels for putting on mailing boxes. I have various info on the label for our internal warehouse--order number, shirt type, box type, etc. that I pull from a ODBC database. However, I also need to include what box number is with the order. For instance, if someone orders 5 boxes of long sleeve shirts, I want to have a total of 5 labels printed out with each label having 1, 2, 3, 4, and 5 on them respectively.
My database is set up to open in the form mode where one of the employees can enter the order number in a combo box. The box then pulls all the info associated with the order number and displays on the screen. The employee can then click on a print button on the form which automatically prints the label report from the info previously displayed on the screen. However, right now, it only prints the one label that is associated with the order number.
I think that what I would have to do is have a question pop up asking for how many total boxes are with the order after someone clicks the print button...but am not sure how to do this...especially with the sequential numbering.
Any help would be GREATLY appreciated. Please be pretty detailed since I am a relatively new Access user.
Thanks
Rob
I am trying to set up an Access database to print up labels for putting on mailing boxes. I have various info on the label for our internal warehouse--order number, shirt type, box type, etc. that I pull from a ODBC database. However, I also need to include what box number is with the order. For instance, if someone orders 5 boxes of long sleeve shirts, I want to have a total of 5 labels printed out with each label having 1, 2, 3, 4, and 5 on them respectively.
My database is set up to open in the form mode where one of the employees can enter the order number in a combo box. The box then pulls all the info associated with the order number and displays on the screen. The employee can then click on a print button on the form which automatically prints the label report from the info previously displayed on the screen. However, right now, it only prints the one label that is associated with the order number.
I think that what I would have to do is have a question pop up asking for how many total boxes are with the order after someone clicks the print button...but am not sure how to do this...especially with the sequential numbering.
Any help would be GREATLY appreciated. Please be pretty detailed since I am a relatively new Access user.
Thanks
Rob