C
Chris B via AccessMonster.com
Please help,
I have a very simple database in which I need to print, email & output only
the current page that im working on (a report has been created),currently
it emails and outputs ALL the info on the table, I have the command buttons
on the form. Following your discussions I came right on the Printing issue,
all that remains is the output to and email. I would prefer to keep to
Snapshot format.Below is the info for the printing from VBA which works OK,
hoping someone can show me what I need to change for outout and email in
snapshot format - Many thanks.
Private Sub Print_POA_Click()
On Error GoTo Err_Print_POA_Click
Dim stDocName As String
stDocName = "POA Details"
DoCmd.OpenReport stDocName, acNormal, , "[POA Details.ID]=" & Me![POA
Details.ID]
Exit_Print_POA_Click:
Exit Sub
Err_Print_POA_Click:
MsgBox Err.Description
Resume Exit_Print_POA_Click
End Sub
I have a very simple database in which I need to print, email & output only
the current page that im working on (a report has been created),currently
it emails and outputs ALL the info on the table, I have the command buttons
on the form. Following your discussions I came right on the Printing issue,
all that remains is the output to and email. I would prefer to keep to
Snapshot format.Below is the info for the printing from VBA which works OK,
hoping someone can show me what I need to change for outout and email in
snapshot format - Many thanks.
Private Sub Print_POA_Click()
On Error GoTo Err_Print_POA_Click
Dim stDocName As String
stDocName = "POA Details"
DoCmd.OpenReport stDocName, acNormal, , "[POA Details.ID]=" & Me![POA
Details.ID]
Exit_Print_POA_Click:
Exit Sub
Err_Print_POA_Click:
MsgBox Err.Description
Resume Exit_Print_POA_Click
End Sub