How to print a particular label in a page?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In msaccess database I have created report of 10 labels in a page. The label
will increase to multiple pages once my data entry for lables increase. One
label for one person. I have adhesive label to print. For example I printed
first raw three colums. Next time I print 2nd raw and any of the colum as I
need. What is the facilities in msaccess to print this way? Would
appreciate your favor in this regard.

(e-mail address removed)
 
In msaccess database I have created report of 10 labels in a page. The label
will increase to multiple pages once my data entry for lables increase. One
label for one person. I have adhesive label to print. For example I printed
first raw three colums. Next time I print 2nd raw and any of the colum as I
need. What is the facilities in msaccess to print this way? Would
appreciate your favor in this regard.

(e-mail address removed)
Click to expand...

This is not the correct way to do this.
The correct way would be to only select those records you want to
print (by filtering the records) and than printing that whole batch
(whether it's one record label or hundreds).
How you select those records is determined by your needs.
If you wish to print certain customers that do not fit into a
particular pattern, add a check box to your customer table. Add the
check box field to your form. Select those customers by placing a
check in the check box field. Then code a command button on the form
DoCmd.OpenReport "LabelReport", acViewPreview, , "[CheckField] = -1"

Only the selected customers will be shown in the label report. Print
the whole report.
After the report is run, you can clear all the checks by running an
Update Query:

CurrentDb.Execute "Update YourTable set YourTable.CheckField =
0;",dbFaiOnError

If the labels do fit into a pattern, for example a customer's ZIP
code, you would use a similar method, just change the Where clause:

DoCmd.OpenReport "LabelReport",acViewPreview, , "[ZIPCode]= '12345'"

It's much easier that it looks.
 
Back
Top