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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 | |
|
|