Starting label

  • Thread starter Thread starter Stu
  • Start date Start date
S

Stu

I have a label report that customers run. Often times they will print off,
say, six labels on a new sheet of label stock using the report. The page of
labels has, say, 27 labels on it, so they would like to reuse the label page
for the next report, and specify that the run should start at the eighth
label. Creating a form that asks them for the starting label number is easy
enough, but in VBA how would I specify the starting label number for the
label report? Would I have to pad the recordset with some blank records at
the front to force the first real record to print at the right starting
label number? Or is there a better way? Using Access XP.

Stu W.
 
Allen,

Thank you so much for your posting... this was the
solution to my label report problem, as well!

BJS
 
Great!

I'd just like to point out that while the article provides a good solution
for skipping used labels, it is not a good solution for printing multiples
of a label where the label run spans several pages. Since it relies on the
report events, and Access may not fire the events for all the intervening
pages if you just print/preview part of the report, you can get the wrong
results in that case.

For an alternative solution to the second issue, see:
Printing a Quantity of a Label
at:
http://members.iinet.net.au/~allenbrowne/ser-39.html
 
Back
Top