I get the following error when I try to automatically save my report in .snp format.
"The formats that enable you to output data as a Microsoft Excel, rich-text-format, MS-DOS test, or HTML file are missing from the Windows registry"
This is the command button code:
------
Private Sub Preview_Cal_Cert_Click()
On Error GoTo Err_Preview_Cal_Cert_Click
Dim stDocName As String
DoCmd.Minimize
stDocName = "Form_Cal_Certificate"
DoCmd.OpenReport stDocName, acPreview
DoCmd.OutputTo _
acOutputReport, , acFormatSNP, _
"T:\Calibration Lab\Calibration Certs\2003 Certs\" & "Cert " & ReportNumberName.Value & ".snp"
Exit_Preview_Cal_Cert_Click:
Exit Sub
Err_Preview_Cal_Cert_Click:
MsgBox Err.Description
Resume Exit_Preview_Cal_Cert_Click
End Sub
--------
Thanks for any help
"The formats that enable you to output data as a Microsoft Excel, rich-text-format, MS-DOS test, or HTML file are missing from the Windows registry"
This is the command button code:
------
Private Sub Preview_Cal_Cert_Click()
On Error GoTo Err_Preview_Cal_Cert_Click
Dim stDocName As String
DoCmd.Minimize
stDocName = "Form_Cal_Certificate"
DoCmd.OpenReport stDocName, acPreview
DoCmd.OutputTo _
acOutputReport, , acFormatSNP, _
"T:\Calibration Lab\Calibration Certs\2003 Certs\" & "Cert " & ReportNumberName.Value & ".snp"
Exit_Preview_Cal_Cert_Click:
Exit Sub
Err_Preview_Cal_Cert_Click:
MsgBox Err.Description
Resume Exit_Preview_Cal_Cert_Click
End Sub
--------
Thanks for any help