3011 - run time error (1 Viewer)

[datacontrol]

I get the following error when attempting to export a report to excel via vba:

The Microsoft Jet Database engine could not find the object 'over view report'. Make sure it exists and that you spell its name and the path name correctly.

This is really driving me nuts. Below is my command button code:

Private Sub ReadDoc1_Click()
Dim FileName As Variant
Dim Response As Integer
Dim Home As String

'
' Check Dialog Box values
'

If (Nz(Me.FileName, "x") = "x") Then
Response = MsgBox("You must specify an input file.")
Exit Sub

End If

DoCmd.OutputTo acExport, Forms!SB!Combo185, acFormatXLS, Me.FileName, True


MsgBox "The '" & Forms!SB!Combo185 & "' has been exported.", vbOKOnly

DoCmd.Close acForm, "ReadSubsystemDocument5"
End Sub

 

[dcx693]

Are you sure you have the proper DoCmd.OuputTo syntax?

 

[datacontrol]

Are you sure you have the proper DoCmd.OuputTo syntax?

I have tried many instances of the DoCmd.OutputTo syntax, this one gets me the closest. I don't understand why it is saying that it can't find this report, it definately exists!

 

[dcx693]

According to my Access help system, these are your options for the first parameter of the OutputTo method:

acOutputForm
acOutputModule
acOutputQuery
acOutputReport
acOutputTable

 

[datacontrol]

According to my Access help system, these are your options for the first parameter of the OutputTo method:

acOutputForm
acOutputModule
acOutputQuery
acOutputReport
acOutputTable

Thanks a million, this works.