473,569 Members | 2,870 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problems Printing Mailing Labels...

I print mailing labels out of Access 2000 databases about 3 to 4 times a
week. I have been having problems with one thing since I have been printing
mailing labels.

I print mailing labels by using a report I created and then printing them on
a continuous-feed dot matrix printer. I used the Label Wizard, chose the
query I created, picked the 'Avery USA 4146' (1 7/16" x 4") - 3 across,
paper size: 'Fanfold 358mm x 12 in', and Printer: 'Epson EX-100' -
continuous feed.

Now that I have given the specs of the report, my problem is that when I
print the labels, the top edge creeps up every line. For instance, the top
row the first line will start at 20 mm, the next line will start at 15 mm,
the next line will start at 10 mm, and so on. So that near the bottom of the
page, the labels are overlapping each other. The only way that I have been
able to fix this, is by starting the top line like at 40 mm, and the bottom
row of labels will just be at exactly the top of the label.

Please help me, this is a problem that not only I have had at this company,
but others before me could not fix it.

If you need anymore specific information, just ask. I really need this to be
fixed because we are starting to get a heavier volume of labels, and it is
really starting to be a pain in the but to deal with.

Thanks for any and all help,
Grim Reaper
Nov 12 '05 #1
3 4306
MS Word shows this label as one across. It also shows the height of the
label as 1.44", 1 7/16"=1.4375". This would be enough to cause creep
(0.0025" = 0.0635 mm), but not as much as you're seeing. Access also shows
the 4146 as one across, but uses the 1 7/16" measurement. Since the labels
you are using are 3 across, they probably aren't quite the same and may be
off a little on the size. To allow for this, you will need to adjust the
height of the label. Since it creeps upward, you need to increase the height
of the label or, if the labels don't touch each other, adjust the spacing
between labels. This would be done by adjusting the "vertical pitch", which
is the distance from the top of one label to the top of the next label. The
easiest way to do this would be to increase the height of the detail section
slightly, just remember not to put any controls there if there is spacing
between the labels or you'll print on the backing paper instead of the
label. If you are getting 5 mm creep, the adjustment in inches would be
0.19685", round this off as close as you can to what Access will allow for
size increments.

--
Wayne Morgan
Microsoft Access MVP
"Grim Reaper" <gr*****@nospam .com> wrote in message
news:06******** ************@co mcast.com...
I print mailing labels out of Access 2000 databases about 3 to 4 times a
week. I have been having problems with one thing since I have been printing mailing labels.

I print mailing labels by using a report I created and then printing them on a continuous-feed dot matrix printer. I used the Label Wizard, chose the
query I created, picked the 'Avery USA 4146' (1 7/16" x 4") - 3 across,
paper size: 'Fanfold 358mm x 12 in', and Printer: 'Epson EX-100' -
continuous feed.

Now that I have given the specs of the report, my problem is that when I
print the labels, the top edge creeps up every line. For instance, the top
row the first line will start at 20 mm, the next line will start at 15 mm,
the next line will start at 10 mm, and so on. So that near the bottom of the page, the labels are overlapping each other. The only way that I have been
able to fix this, is by starting the top line like at 40 mm, and the bottom row of labels will just be at exactly the top of the label.

Please help me, this is a problem that not only I have had at this company, but others before me could not fix it.

If you need anymore specific information, just ask. I really need this to be fixed because we are starting to get a heavier volume of labels, and it is
really starting to be a pain in the but to deal with.

Thanks for any and all help,
Grim Reaper

Nov 12 '05 #2
Your problem doesn't sound like an Access problem unless an identical setup
to the same printer using the same labels works perfectly from a different
application, such as Word - you didn't say that was true.

The problem as you have communicated it seems to be one of registration
between what the software (at some level) has been told is true of the
labels and what is actually out there. In short, a registration problem.
Not having all of the facts, I can only guess but the software may believe
that there's a 5 mm gap between label rows. Is there a gap between rows of
labels on the actual sheet? How big? Does the Avery 4146 setup have a gap
between labels? How big? Could it be that the problem you're experiencing
is simply that of using an English dimensioned report to print to Metric
dimensioned labels? It would have been more amazing if the registration
remained true.

While it isn't an Access problem, you can solve it there. You can design
your own label in Access to fit the labels you're using. I recommend
staying within one measurement system rather than designing labels to the
English system and printing them on labels dimensioned in the metric system.

HTH
--
-Larry-
--

"Grim Reaper" <gr*****@nospam .com> wrote in message
news:06******** ************@co mcast.com...
I print mailing labels out of Access 2000 databases about 3 to 4 times a
week. I have been having problems with one thing since I have been printing mailing labels.

I print mailing labels by using a report I created and then printing them on a continuous-feed dot matrix printer. I used the Label Wizard, chose the
query I created, picked the 'Avery USA 4146' (1 7/16" x 4") - 3 across,
paper size: 'Fanfold 358mm x 12 in', and Printer: 'Epson EX-100' -
continuous feed.

Now that I have given the specs of the report, my problem is that when I
print the labels, the top edge creeps up every line. For instance, the top
row the first line will start at 20 mm, the next line will start at 15 mm,
the next line will start at 10 mm, and so on. So that near the bottom of the page, the labels are overlapping each other. The only way that I have been
able to fix this, is by starting the top line like at 40 mm, and the bottom row of labels will just be at exactly the top of the label.

Please help me, this is a problem that not only I have had at this company, but others before me could not fix it.

If you need anymore specific information, just ask. I really need this to be fixed because we are starting to get a heavier volume of labels, and it is
really starting to be a pain in the but to deal with.

Thanks for any and all help,
Grim Reaper

Nov 12 '05 #3
Thank you so much for your help. I did exactly what you had suggested (using
a ruler to make EXACT measurements). Now, it finally worked!!!!!

The company that I am working for said that they could not get it to work
for more than a year!!!

Thanks for your help, I really appreciate it,
Grim Reaper

"Wayne Morgan" <co************ *************** @hotmail.com> wrote in message
news:JB******** ******@newssvr3 3.news.prodigy. com...
MS Word shows this label as one across. It also shows the height of the
label as 1.44", 1 7/16"=1.4375". This would be enough to cause creep
(0.0025" = 0.0635 mm), but not as much as you're seeing. Access also shows
the 4146 as one across, but uses the 1 7/16" measurement. Since the labels
you are using are 3 across, they probably aren't quite the same and may be
off a little on the size. To allow for this, you will need to adjust the
height of the label. Since it creeps upward, you need to increase the height of the label or, if the labels don't touch each other, adjust the spacing
between labels. This would be done by adjusting the "vertical pitch", which is the distance from the top of one label to the top of the next label. The easiest way to do this would be to increase the height of the detail section slightly, just remember not to put any controls there if there is spacing
between the labels or you'll print on the backing paper instead of the
label. If you are getting 5 mm creep, the adjustment in inches would be
0.19685", round this off as close as you can to what Access will allow for
size increments.

--
Wayne Morgan
Microsoft Access MVP
"Grim Reaper" <gr*****@nospam .com> wrote in message
news:06******** ************@co mcast.com...
I print mailing labels out of Access 2000 databases about 3 to 4 times a
week. I have been having problems with one thing since I have been printing
mailing labels.

I print mailing labels by using a report I created and then printing them on
a continuous-feed dot matrix printer. I used the Label Wizard, chose the
query I created, picked the 'Avery USA 4146' (1 7/16" x 4") - 3 across,
paper size: 'Fanfold 358mm x 12 in', and Printer: 'Epson EX-100' -
continuous feed.

Now that I have given the specs of the report, my problem is that when I
print the labels, the top edge creeps up every line. For instance, the
top row the first line will start at 20 mm, the next line will start at 15 mm, the next line will start at 10 mm, and so on. So that near the bottom of

the
page, the labels are overlapping each other. The only way that I have been able to fix this, is by starting the top line like at 40 mm, and the

bottom
row of labels will just be at exactly the top of the label.

Please help me, this is a problem that not only I have had at this

company,
but others before me could not fix it.

If you need anymore specific information, just ask. I really need this to be
fixed because we are starting to get a heavier volume of labels, and it

is really starting to be a pain in the but to deal with.

Thanks for any and all help,
Grim Reaper


Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
3930
by: Murray Elliot | last post by:
Just wondering if anyone has any ideas on how to solve a particular problem. A client wants to print barcode labels from their (web/php based application). The barcode labels are very small, so I'm guessing that doing a screendump via a standard inkjet isn't going to work (i.e. might need somehow to print to a barcode printer!) Any ideas...
1
1496
by: Nick | last post by:
Hi, I'm converting an existing VB/Access app into an ASP.Net Intranet app. Most of the conversion is pretty straight forward - except the printing! The old app prints mailing labels on Avery stationary - but I can't see how I can replicate this from the ASP... Any ideas on how to do this? Conversion into Word/Excel (we have v2003) is ok,...
6
1169
by: Rand | last post by:
Hello anyone, Situation: I want to print 1 or x mailing continuous form labels 1" X 3.5" then change to a different name and print again. Everything works fine except for problem below. Problem: Unwanted form feed after printing.
2
13494
by: Mikey | last post by:
Sample VB .NET source code to create mailing labels or customized letters using MS Word MailMerge This VB .NET source code will start MS Word and call methods and set properties in MS Word to execute a MailMerge to create mailing labels or customized letters. A label name known to MS Word MailMerge mailing label wizard may be used or a...
4
4377
by: G0ng | last post by:
Hello. I 've developed an application for secretaries in universities so as to save the student's data, grades, etc. One last thing I have to do is print some reports. For example all the grades of a studentin his 4 year studies. I think I shouldn't stick to html, because I want to manipulate the pages as I please. I thought of making...
6
8633
by: Ron | last post by:
Hi, I know Access allows for easy construction of a report setup to print labels from a table/query, etc. I've done that one. It works pretty well for what I need. However, is there an example anywhere that someone can point me to that is more flexible? And, I mean flexible in this regard:
7
2008
by: Dave | last post by:
Hi all I have a student database where I would like to be able to print just one mailing label, for the student whose record I am currently accessing on the form. I want to be able to click on the command button and have the label print out on my labelwriter. I have done some searching on the web, and found how to print single labels...
29
15420
by: FredBear | last post by:
I am just coming to grips with php, Dreamweaver and MySQL and I want to make a facility available for the members of the group I am creating my web site for. I want them to be able to print-out a list of address labels, using standard Avery labels, on their home PC's using the data from my MySQL tables. I am not yet sufficiently au fait with...
5
2793
by: Ron | last post by:
Hi All, I've got a report that prints mailing labels. It utilizes a routine that asks the number of labels to skip, the number of each label to print, and then prints. It works really well on a print preview. But,when I print to the printer it disregards the number of labels to skip. I preview all the reports I've got and then have a...
0
7605
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7917
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7962
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6277
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5501
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5217
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3651
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3631
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
933
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.