|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
January 16th, 2004, 10:56 AM
|
|||
|
|||
Mailing a sigle record form
Hello,
I have a database where I can input call centre agents performance to a table. In the Form I have it so I can preview a report for the single record I am currently modifying. What I would like to do is to be able to email this form in .snp format with only that record. The only way I have managed to find to do it was by previewing the form with that single record, right click on this form and click on send. There must be a way for this to be done automatically. Does anyone know how I could go about doing this? This is my preview button code: Code:
Private Sub Command248_Click()
On Error GoTo Err_Command248_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "QualityMonitoringReport"
stLinkCriteria = "QM_ID=" & Me.QM_ID
DoCmd.OpenReport stDocName, acNormal, , stLinkCriteria
Exit_Command248_Click:
Exit Sub
Err_Command248_Click:
MsgBox Err.Description
Resume Exit_Command248_Click
End Sub
Thanks! 
|
|
#2
January 16th, 2004, 11:38 AM
|
|||
|
|||
|
I fixed it! In case anyone wants to know how to do it, I changed the preview code to:
Code:
Private Sub ViewQM_Click()
On Error GoTo Err_ViewQM_Click
Dim StDocName As String
Dim stLinkCriteria As String
StDocName = "QualityMonitoringReport"
stLinkCriteria = "QM_ID=" & Me.QM_ID
DoCmd.OpenReport StDocName, acPreview, , stLinkCriteria
DoCmd.SendObject acSendReport, StDocName
DoCmd.Close
Exit_ViewQM_Click:
Exit Sub
Err_ViewQM_Click:
MsgBox Err.Description
Resume Exit_ViewQM_Click
End Sub
|
|
| Viewing: ASP Free Forums > Database > Microsoft Access Help > Mailing a sigle record form |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
