C
Christine
Hi guys,
I have a situation where a button in my Access database no longer works. It
worked fine in Access 2003, but not in Access 2007.
The button works like this - a query is run to get a table of results and a
form pops up. The button is on this form. Clicking the button used to give
the user a choice of formats to export the form to. When the button is
clicked on, the Output To dialog box appears, but it doesn't matter which
format I pick, I get this error message:
The Microsoft Office Access database engine could not find the object
"ExportPotentialWords". Make surethe object exists and that you spell its
name and the path correctly.
The code behind the button is:
Private Sub Exporto_Click()
On Error GoTo Err_Exporto_Click
Dim stDocName As String
stDocName = "GetPotentialNPTs"
DoCmd.OutputTo acQuery, stDocName
Exit_Exporto_Click:
Exit Sub
Err_Exporto_Click:
MsgBox Err.Description
Resume Exit_Exporto_Click
End Sub
How can I get the button working again?
I have a situation where a button in my Access database no longer works. It
worked fine in Access 2003, but not in Access 2007.
The button works like this - a query is run to get a table of results and a
form pops up. The button is on this form. Clicking the button used to give
the user a choice of formats to export the form to. When the button is
clicked on, the Output To dialog box appears, but it doesn't matter which
format I pick, I get this error message:
The Microsoft Office Access database engine could not find the object
"ExportPotentialWords". Make surethe object exists and that you spell its
name and the path correctly.
The code behind the button is:
Private Sub Exporto_Click()
On Error GoTo Err_Exporto_Click
Dim stDocName As String
stDocName = "GetPotentialNPTs"
DoCmd.OutputTo acQuery, stDocName
Exit_Exporto_Click:
Exit Sub
Err_Exporto_Click:
MsgBox Err.Description
Resume Exit_Exporto_Click
End Sub
How can I get the button working again?