Printing one envelope?

  • Thread starter Thread starter klack
  • Start date Start date
K

klack

How do you print one envelope from a database of names and
addresses in Access? I can print labels, I can create sub
groups of data, but cannot figure out how to print one
envelope from the list.
 
I am attempting to do same thing. I am able to PrintPreview, but when I click
Print it print all 168 records.
I need to know how to print one envelope for the record I am viewing.
Thanks.
Joan
 
Do something like this
You must replace employeeNo with your unique identifying number or sting

Dim stLinkCriteria As String
stLinkCriteria = "[EmployeeNo]=" & Str(Nz(Me![EmployeeNo], 0))
Dim stDocName As String

stDocName = "EmpPayRpt" ' your report name
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria
Alfred
 
Yes. The following is the code that allows everything to happen except for me
the option to select the printing of an envelope for the record I am viewing.

stDocName = "Envelope"
DoCmd.OpenReport stDocName, acViewPreview
Any help appreiciated. Joan
Alfred said:
Do something like this
You must replace employeeNo with your unique identifying number or sting

Dim stLinkCriteria As String
stLinkCriteria = "[EmployeeNo]=" & Str(Nz(Me![EmployeeNo], 0))
Dim stDocName As String

stDocName = "EmpPayRpt" ' your report name
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria
Alfred


JoanOC said:
I am attempting to do same thing. I am able to PrintPreview, but when I
click
Print it print all 168 records.
I need to know how to print one envelope for the record I am viewing.
Thanks.
Joan
Click to expand...
Click to expand...
 
Back
Top