labels

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

I have an access ordering database set up. when i enter an order i
want to be able to print a deliverly label.

How do i just print one lablel and how do i specifi which label on the
A4 sheet to print to


As on MS Word Label application you can select which label to print to
by selecting the colum and row


Can any more help


Simon
 
You have to create a report, rptLabel, which prints one label per page.
I assume that each label has some unique ID, for example LabelID.
Then, on your label entry form, you place a commnd button, cmdPrintLabel.
On buttons On_Click code you need to put something liek this:

sub cmdPrintLabel_Click()

DoCmd.OpenReport ReportName:="rptLabel", WhereCondition:="LabelID=" &
me!LabelID

end sub

I may have made some typos, so do not cut/paste my code. The key is to use
WhereCondition parameter in the DoCmd.OpenReport statement.
 
Back
Top