A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

MS Access 2007 Dot Matrix Label Printing



 
 
Thread Tools Display Modes
  #1  
Old August 28th, 2009, 04:13 PM posted to microsoft.public.access.reports
nuketechie
external usenet poster
 
Posts: 1
Default MS Access 2007 Dot Matrix Label Printing

Hi thanks for your help in advance. In an Access 2007 report, I am trying
print a specified qty of 1" x 3.5" labels using a DOT Matrix printer. I've
setup of the label wizard with 1 column printing, continuous sheet, and the
necessary label dimensions.

Apparently MS Access will only print 1 of the same label (record) per sheet.
So if you print 10 labels you get 10 labels on 10 sheets. I created a
module using the MS article addressing this printing issue. It can be found
here along with the code that I used:
http://support.microsoft.com/default.aspx/kb/95806

Here's the problem I'm having: When I enter 0 for the "blank labels" prompt
and say 5 for "number of copies" prompt, MS Access prints 5 then form feeds
the rest of the way as if it were a single sheet of 8.5x11 piece of paper.
This is desired result if you only want 5 labels printed. Unfortunately if I
enter 11 or more copies then it prints 10 labels, feeds past 1 label, then
prints 10 more and keeps printing like this indefinitely. It seems like
there is some type of looping problem with the code. I never changed the
original code that is reference in the article above.

I need to print how every many labels I need on a continuous form feed dot
matrix printer and then have it stop printing after the last label needed.
If it form feeds the rest of the way for several more labels then stops then
this isn't a problem. The non-stop printing is obviously the problem.

Any ideas anyone?

Thanks!

Kent
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:27 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.