Increment Number on Label (2000)

Topic

New Reply

I want to have a database which has names and job numbers then prints out preformatted labels with an incrementing number on it – eg I decide to print 100 labels to be stuck on a delivery to Fred Nurks, job 27. The first label would be 1 with Freds Address and job 27, the second would be 2 with Freds Address and job 27 etc
Any suggestions appreciated
TIA
Steve

Reply | Quote

Replies

There are perhaps two parts to your question. I am not sure if you are asking both.

You can print multiple copies of the same label, and number them using the Print event of the Detail section of the labels report, by using the PrintCount property of the report.

Assuming the number of labels is specified on a form, say frmLabelsCriteria, use this:

if Printcount < forms!frmLabelCriteria!txtNumberofLabels then
me.NextRecord = false
me!txtCount =printCount
end if

where txtCount is an unbound text box on the labels

Reply | Quote

John,

Very Clever. Thanks.

Reply | Quote

John,

Very Clever. Thanks.

Reply | Quote

There are perhaps two parts to your question. I am not sure if you are asking both.

You can print multiple copies of the same label, and number them using the Print event of the Detail section of the labels report, by using the PrintCount property of the report.

Assuming the number of labels is specified on a form, say frmLabelsCriteria, use this:

if Printcount < forms!frmLabelCriteria!txtNumberofLabels then
me.NextRecord = false
me!txtCount =printCount
end if

where txtCount is an unbound text box on the labels

Reply | Quote

Edited by WendellB to activate links to the MSKB article – see Help 19
Here is an article from Microsoft that might help you out a lot. it is not on Increment numbering but it is on how to print multiple copies of the same mailing label, and how to use a partially used page where only some of the labels are available.
Microsoft Knowledge Base Article – 299024
Microsoft Knowledge Base Article 299024
http://support.microsoft.com/default.aspx?…kb;EN-US;299024%5B/url%5D
I hope that this gives you some ideas to figure out your little problem.

Reply | Quote

Thanks all very much for the great help
Steve

Reply | Quote

Thanks all very much for the great help
Steve

Reply | Quote

Edited by WendellB to activate links to the MSKB article – see Help 19
Here is an article from Microsoft that might help you out a lot. it is not on Increment numbering but it is on how to print multiple copies of the same mailing label, and how to use a partially used page where only some of the labels are available.
Microsoft Knowledge Base Article – 299024
Microsoft Knowledge Base Article 299024
http://support.microsoft.com/default.aspx?…kb;EN-US;299024%5B/url%5D
I hope that this gives you some ideas to figure out your little problem.

Reply | Quote