By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,584 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Numbering Labels

P: n/a
I need to print out labels (which are set up as a a report) from form.
I can tell access how many labels to print, but I also want to add to
each label "Box 1 of 5", "Box 2 of 5", "Box 3 of 5" etc etc. My labels
are 2 up to sheet.
Any ideas ?

Many Thanks

Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
See:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

The article explains how to use a query to generate a record for each label
to be printed, and add the counter to the label.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ca***********@yahoo.co.uk> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
I need to print out labels (which are set up as a a report) from form.
I can tell access how many labels to print, but I also want to add to
each label "Box 1 of 5", "Box 2 of 5", "Box 3 of 5" etc etc. My labels
are 2 up to sheet.
Any ideas ?

Many Thanks

Nov 13 '05 #2

P: n/a
See:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

The article explains how to use a query to generate a record for each label
to be printed, and add the counter to the label.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ca***********@yahoo.co.uk> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
I need to print out labels (which are set up as a a report) from form.
I can tell access how many labels to print, but I also want to add to
each label "Box 1 of 5", "Box 2 of 5", "Box 3 of 5" etc etc. My labels
are 2 up to sheet.
Any ideas ?

Many Thanks

Nov 13 '05 #3

P: n/a
Thats great, but my labels are 2 up to a sheet. So, how do I get 1 of 5
on the top label, 2 of 5 on the bottom, 3 of 5 on the top label of the
next and so on. ?

Nov 13 '05 #4

P: n/a
Thats great, but my labels are 2 up to a sheet. So, how do I get 1 of 5
on the top label, 2 of 5 on the bottom, 3 of 5 on the top label of the
next and so on. ?

Nov 13 '05 #5

P: n/a
Use the Label Wizard (when you create a report) to generate the report that
is laid out as you wish. Select the query as the source.

If the result does not sort correctly, you can switch to design view, and
use the Sorting And Grouping box (View menu) to specify the sort order.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ca***********@yahoo.co.uk> wrote in message
news:11********************@o13g2000cwo.googlegrou ps.com...
Thats great, but my labels are 2 up to a sheet. So, how do I get 1 of 5
on the top label, 2 of 5 on the bottom, 3 of 5 on the top label of the
next and so on.

Nov 13 '05 #6

P: n/a
Use the Label Wizard (when you create a report) to generate the report that
is laid out as you wish. Select the query as the source.

If the result does not sort correctly, you can switch to design view, and
use the Sorting And Grouping box (View menu) to specify the sort order.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ca***********@yahoo.co.uk> wrote in message
news:11********************@o13g2000cwo.googlegrou ps.com...
Thats great, but my labels are 2 up to a sheet. So, how do I get 1 of 5
on the top label, 2 of 5 on the bottom, 3 of 5 on the top label of the
next and so on.

Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.