473,836 Members | 1,967 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Label Printing

I have a simple database of addresses each with unique key and the user
is able to create a table of selected keys and how many labels they
need for each. The print program, using label counting techniques,
shows, in print preview, the correct number of labels.
When printed, though, the first keyed entry sometimes prints correctly
with, say, 6 labels, or sometimes with 2 or 4. All the following keys
have their correct number of labels printed.
In Access 2000 but tried in 2003 with same result and to different
printers.

Jun 13 '06 #1
4 3416
How are you instructing Access to print the quantity of each label?

One common approach is to use code in the reports events. This won't work
reliably: it has exactly the problems you describe.

For details and an alternative, see:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

--
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.

"Wayne" <wa***********@ nhs.net> wrote in message
news:11******** **************@ p79g2000cwp.goo glegroups.com.. .
I have a simple database of addresses each with unique key and the user
is able to create a table of selected keys and how many labels they
need for each. The print program, using label counting techniques,
shows, in print preview, the correct number of labels.
When printed, though, the first keyed entry sometimes prints correctly
with, say, 6 labels, or sometimes with 2 or 4. All the following keys
have their correct number of labels printed.
In Access 2000 but tried in 2003 with same result and to different
printers.

Jun 13 '06 #2

On 13-Jun-2006, "Allen Browne" <Al*********@Se eSig.Invalid> wrote:
For details and an alternative, see:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html


That is one slick solution. Simple. Pragmatic. Bulletproof for all
practical purposes. I wish I'd thought of it.
Jun 13 '06 #3

w_a_n_n_a_l_l_-@-_s_b_c_g_l_o_b_ a_l._n_e_t wrote:
On 13-Jun-2006, "Allen Browne" <Al*********@Se eSig.Invalid> wrote:
For details and an alternative, see:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html


That is one slick solution. Simple. Pragmatic. Bulletproof for all
practical purposes. I wish I'd thought of it.


Jun 14 '06 #4
Having trouble replying. Thanks for the above. I did add a report
header and initialised the label count there and it is now fine. Page
Preview is not wysiwyg - how could I have known this in advance?
Cheers

Jun 14 '06 #5

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

Similar topics

3
4121
by: RC | last post by:
I am using docmd.printout to send Reports (formatted as labels) to a barcode label printer. I need to collate the labels so that I print lable 1 twice, then label 2 twice, then label 3 twice, etc. The printout collate option only seems to work if the printer supports it. The label printer I am using doesn't collate via the printout command option, but it does have a command language that will collate IF I can find a way to send the...
1
2462
by: achintya.jha | last post by:
Hi, I am currently working hard to print Word labels from ASP.NET I have multiple records which I need to print on to a word label print functionality. I know that Word Label printing prints the same label multiple times on the printer. I have to print multiple labels on to the same page and then the printer. So, I think I have to use Mail-Merge and then Word Label Print. I also need the standard label printing dialog to open before...
3
15046
by: Michael | last post by:
Hi, I'm trying to print barcodes to the Dymo LabelWriter printer. Put everytime I send a job to the label printer it just outputs an empty label. If I change the default printer back to the standard printer(HP LaserJet), it prints fine. Has anyone worked with Label printers like this. Here is the code I'm using: Private Sub cmdPrint_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdPrint.Click try Dim BarCode...
56
14079
by: peng | last post by:
Hi, I am development a project using C#.Net. Inside application, it needs to print labels on different Zebra label printers on the network. I used a shell script, but it only worked on the server machine locally. Anybody knows how to do it? Thanks, Peng
2
3705
by: Beginner | last post by:
I have to print a Fedex shipping label on a Zebra(thermal) printer. I initially had the label information in a base64 string which I decoded into a memory stream. Now I need to send this memory stream to a thermal/label printer. How do I do this? Thanks for any help.
1
6964
by: steve | last post by:
Hi All Has anybody had experience with printing text and barcodes to Zebra label printers in VB.net 2005 Regards Steve
1
3099
by: =?Utf-8?B?R2VvcmcgRmxlaXNjaGVy?= | last post by:
Hello, I've got a problem which I can not locate. I will try to describe it and would be glad, if someone had an idea how to identify the cause of the problem. Situation: My application prints labels to a label printer (Datamax E-4203) via PrintDocument. The PrintDocument prints a new page for each label, so with 4 labels printed at once I have a 4-page document - sounds easy - is easy.
0
2087
by: jinsatoemo | last post by:
Hello guys,i'm new here,nice to meet you all :-) I need some help in access,particularly in printing to label printers.I've developed a program that generate labels to print to a label printer(Datamax E-4203).The problem is,the label prints to that printer but it doesn't print fast(print 1 label,pause 1 sec,print 1 label,pause again and so on).If I'm using a commercial label maker program like Teklynx Labelview,the label will print very fast...
1
1715
by: vfpgood | last post by:
Hello,guy! My work is to design labels. Can anyone introduce a simple, easy and professional system for bar code label design . Set design drawings, generate bar code generation and batch printing in one. I have found a software called "Label mx pro",and I have use "label mx pro" for several month.The application work excellent!Now I am considering to buy it .Label mx pro is up to $200,so i much think twice.
0
9810
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9656
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10526
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10240
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7772
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6972
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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5641
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
4000
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3100
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.