Solved

How remember what position on a sheet of labels the last label used

Posted on 2013-12-31
3
500 Views
Last Modified: 2014-01-02
I want to print address labels from a label template using Access 2010.  But I don't want to waste any labels.  Is there a way to remember what position on a sheet of labels the last label used so the next time it can start with an unused label?

--Steve
0
Comment
Question by:SteveL13
3 Comments
 
LVL 84
ID: 39748829
Not really, because the user can change out the sheet at any point.

One system I work with allows you to input the number of "used" labels, and the printing starts from there. Basically, there is a routine that determines the number of labels available on the sheet. The user enters the number of "used" labels, and the routine then enters blank data for those labels, and starts the "live" labels at the next available.

So on a sheet of 10 labels (2 columns of 5), if I enter that I've used 3 labels, and I want to print a single label, the routine would enter blank data for 3 labels, live data for a single label, and nothing for the rest. The end result is a sheet with one label in the "4th" position (i.e. the second column, second label down).
0
 
LVL 12

Accepted Solution

by:
pdebaets earned 500 total points
ID: 39749248
You can use our free Label Saver utility: http://peterssoftware.com/ls.htm .  With it, you can specify a label starting position, and a number of copies for each label.
0
 
LVL 45

Expert Comment

by:aikimark
ID: 39751312
In addition to Peter's code, you can switch from sheets of labels to a continuous roll of labels.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question