Skip number of used labels

[pdtit]

Hi,

I'm using a table with stock quantity numbers per product. For each product selected, I want to print labels, according to the amount of products in stock.

To accomplish this, I found the following code to work :

http://www.tek-tips.com/viewthread.cfm?qid=195594

This always worked great as long I used 1-column paper (i.e. a Zebra labelprinter with a roll).

Now, I want to switch to A4 pages with several columns and rows.
When printing my labels, it always starts @ the first row/column. However, I want to tell the "report" to start printing on label 20.

I checked MS KB 299024 "Skip Used Mailing Labels and Print Duplicates in Access 2002", but it doesn't work.

I think it is because I'm using the Printcount twice for 2 different data sets.

Can someone guide me in the right direction ?

Kind regards,

Peter

 

[CosmoKramer]

Peter,

Check out faq703-3276. Hopefully this is what you're looking for....

Hoc nomen meum verum non est.

 

[hymn]

there is some code on the thread below that MIGHT help

thread705-845365

Hope this helps
Hymn