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  

Skip Used Mailing Labels and Print Duplicates in Access 2003 / 2000



 
 
Thread Tools Display Modes
  #1  
Old April 23rd, 2010, 11:23 AM posted to microsoft.public.access.reports
ihightower
external usenet poster
 
Posts: 1
Default Skip Used Mailing Labels and Print Duplicates in Access 2003 / 2000

On Sep 8 2004, 12:04 pm, "pete johnson"
wrote:
Microsoft Knowledge Base Article -231801
kb atricle #231801deals with skipping used labels which would normally be
wasted if you print on part of a sheet of labels. it claims that it is foraccess2000. i just used it onaccess97 and it worked perfectly, the first
time, every time.


http://support.microsoft.com/kb/231801

#231801 is a very useful article..

But, it can be made even better by making it even more generic...

Replace STEP 2 Statement, From This:

=LabelLayout(Reports![MyLabels])

To This:

=LabelLayout([Report])

This way it is so generic that you don't have to change the report
name for each reports... Hope this helps...

Please correct me if I have done something wrong... it looks working
to me so far with this change..

And, it works on Access 2003 as well.


---

I learned this trick while reading through:

http://allenbrowne.com/AppLogDocUse.html


 




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 04:41 PM.


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