Ok i have designed a report to print out labels into on a A4 sheet of paper with labels sticks on (see example below) , i us this to print out multiable address to stick on letters. my problem is that if let say i print 3 sticker out well that Used up slot 1 to 3, my problem is that it now mean that the sheet is wasted and i can use the other slots. so i want a way i can tell my report to print a a number of blank reports of my choosing, that way i can push the address down to print on the place i want. how would i achieve this, or is there a better way of going about this?
If your report is based on a query that treats each record as a sticker, you could try to enhance the recordset by adding as many "blank" records as necessary by programatically editing the RecordsetClone object of your report. Now that's just an idea and you'd need to work out the details but it could work.
I have looked and looked through the code bank, but I can't find it. But a few months ago, I downloaded some sample code in a database called LS2002, and it works great. It does exactly what you need, we were doing the same thing. We would print a few labels from a sheet for labeling parts, and then turn the page over and print a few labels later, and then trash all the labels in the middle. I'm not sure of the protocol or security issues, but since I can't find it in the forum, I would be happy to send it to you.