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 6 1654
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
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
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. ?
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. ?
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.
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Andy Glew |
last post by:
I have long looked for (and occasionally posted
questions to groups such as this about) a tool
that can take a group of HTML pages (nowadays
XHTML, or XML) and produce a nicely formatted...
|
by: Stanimir Stamenkov |
last post by:
So if the 'type' attribute of the OL element is deprecated and
authors should rely only on stylesheets how one could use a
reference (as clear text) in the content to a particular list element?
...
|
by: Christian Roth |
last post by:
Hello,
how do I offset the numbering of a list in XHTML Strict (+CSS) in
current browsers?
What I want is something like:
5. Item a
6. Item b
7. Item c
|
by: Charles McCaffery |
last post by:
I have written a database with auto-numbering and now wish to remove alkl of
my test data and set the auto-numbering back to one. How do I do this
please?
Charles McCaffery.
|
by: Wayne Aprato |
last post by:
I have a report that shows the results of a query. One of the fields
is an autonumber field from the query which shows for instance: 120,
121 , 122 for 3 records. Is there a way to have another...
|
by: Wayne Aprato |
last post by:
I posted this yesterday and it seems like a moderator has thrown it in
another thread. This is a totally different question to the one asked
in that thread, so I'm posting it again. It is not a...
|
by: callieandmark |
last post by:
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...
|
by: Jim Bancroft |
last post by:
Hi all,
In VB6 I used a 3rd party tool for line numbering my source code, to
help with debugging. However, in experimenting with VB .Net I've noticed
that my exceptions automatically provide...
|
by: MLH |
last post by:
I use A97 and do not always insert line numbers while
writing procedures. I find it necessary to go back and
add them later to aid in debugging.
Nearly 3 years ago, something was mentioned in...
|
by: clickingwires |
last post by:
As it stands right now I have a form with a sub form within it. This sub form is a continuous form that I want to have numbered i.e. Element 1, Element 2 ... and so on. I can implement this with Two...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |