printing labels - determining start point

[skemper]

I was hoping there is a simple solution so that I can set up a label maker layout such that I can direct it to which row and column on the page the printing process should start. This will help me use up partially used sheets of labels. Using version 5.

Thanks,

Scott

[slstrother]

The only way I know to do this is to insert the appropriate number of blank records before the label or labels you want to print. Then sort ascending so the blank records show first. You would then need to delete the blank records after printing. If you do this occasionally, performing this manually shouldn't be too cumbersome. If you do this often, you will likely want to script it. You might also consider a separate printing database. I haven't worked this out, but it would go along the lines of find the records you want to print in the main db, import into the printing db, set the starting position, add the blank records, sort, print, then delete all records.

[Lee Smith]

There is an easy way, check out "Aetiket Label Printer", its shareware and cost $15. US available at:

http://www.fmfiles.com/dev8.html

HTH

Lee

[spb]

I have a label maker database where I've placed rows of numbered buttons on the layout in the same pattern as the labels. I have both a six-up shipping label layout and a 30-up mailing label layout that uses this. On the six-up, the buttons look like this (I hope the spacing survives the formatting!):

(4)

(2) (5)

(3) (6)

You don't need a (1) button, because that is simply a fresh sheet of labels.

Each button runs a script that creates the correct number of blank records to force printing to begin where you want it. This makes an easy visuaL cue, a you glance at your partial sheet, note qwhere the next unused label is, then click the button corresponding to that position.

My db is set up for data entry, so we always begin with zero records. My Home button (when finished printing) deletes all records, and I have a delete all startup script. But you could adapt this to importing a bunch of records to be printed by clicking the label position button before importing.

Using this in a database that contains lots of data, where you want to print a found set, could still work. Your buttons would include a sort step after the record creation step and your Home button would do a find for empty unique ID fields, delete found set, then find all & go to layout.

Steve Brown