shipping labels

[humvie]

I'm working on a shipping program at work that generates and prints a generic bill of lading and shipping labels.

Shipping dept is asking to have the option of overriding the quantity of labels required to be printed. That;s not a problem. My problem is once I know how many labels to print, how do I code it to have it show "1 of 15 pieces" on the first label, then "2 of 15 pieces" on the second label, etc ....

Any help would be greatful.

Thanks

 

[CosmoKramer]

Check out this FAQ that I wrote: faq703-3276

You can utilize the incrementing number from the query, and you said you already have your limit number.....

 

[humvie]

I must be having a bad day or just plain dense. I can't seem to grasp what is said in FAQ703-3276.

I created the table as described and called my field ctnQTY. Added that field to my query that supplies the label (report) - and not joined.

I still don't understand how to 1) print x number of labels and 2) how to show "1 of 5 pieces" on the label.

Sorry but can you elaborate?

Thanks again!

 

[CosmoKramer]

You said you already have the user defining the total number of labels they want for each item. I assume this is a text box on a form. On your label report, add a text box whose control source is something like this:

=[ctnQTY] & " of " & [txtHowMany]

replace [txtHowMany] with whatever your control is named. [ctnQTy] is the incremental number generated by the query.

Let me know if this helps.....

 

[humvie]

thank you CosmoKramer, I will work it and let you know.

 

[humvie]

I finally got that label issue licked.
Thanks for your help!!

 

[humvie]

ooops!

Help again. Just noticed that when I enter the number of labels in the text box on the form, then hit the print label button, the quantity does not get relayed to the report unless I get out of it and then re-open the form. I tried requering and even the DoCmd.save method but didn't work.

Any idea what causes this and how to fix it?

 

[CosmoKramer]

If the "number of labels" text box is a bound control, you might want to try a

[b]Me.Refresh[/b]

at the beginning of your print label button. If that doesn't work you might want to make in an unbound control.

 

[CosmoKramer]

If the "number of labels" text box is a bound control, you might want to try a Me.Refresh at the beginning of your print label button code. If that doesn't work you might want to make it an unbound control.

 

[humvie]

thanks again Cosmo