Envelopes in Access

[Cassandra]

I have created a report to reflect a #10 envelope. Now I want to create a
command button that allows me when clicked print an individual envelop that
reflects the information of the member record that I am in, so far no such
luck. How do I correct this?

 

[Damon Heron]

On your form add a command button with the following code (substituting your
info, of course):

Private Sub cmdPrtEnv_Click()
On Error GoTo Err_cmdPrtEnv_Click
Dim stDocName As String

stDocName = "Envelope Printing" 'Enter the name of your report....
DoCmd.OpenReport stDocName, acPreview, , "[ClientID] =
Forms![Projects].form![txtClientID]"
' substitute your formname and controls for client ID.
Exit_cmdPrtEnv_Click:
Exit Sub

Err_cmdPrtEnv_Click:
MsgBox Err.Description
Resume Exit_cmdPrtEnv_Click

End Sub

Damon

 

[Cassandra]

Thank you. I really appreciate your help.

On your form add a command button with the following code (substituting your
info, of course):

Private Sub cmdPrtEnv_Click()
On Error GoTo Err_cmdPrtEnv_Click
Dim stDocName As String

stDocName = "Envelope Printing" 'Enter the name of your report....
DoCmd.OpenReport stDocName, acPreview, , "[ClientID] =
Forms![Projects].form![txtClientID]"
' substitute your formname and controls for client ID.
Exit_cmdPrtEnv_Click:
Exit Sub

Err_cmdPrtEnv_Click:
MsgBox Err.Description
Resume Exit_cmdPrtEnv_Click

End Sub

Damon

I have created a report to reflect a #10 envelope. Now I want to create a
command button that allows me when clicked print an individual envelop
that
reflects the information of the member record that I am in, so far no such
luck. How do I correct this?