R
Randy
Thanks in advance for any help. I have tried using Google for an answer but
haven't found a suitable one.
I developed a Customer Support Database in Access 2003 where two users
in our office use it daily. The database has been split and both users have
Access 2003 installed on their computers. They have no problems running any
of the reports. There are two users (myself included) who have Office 2007
installed - one on Windows XP and one on Vista. Neither of us using Office
2007 can run the reports from the database. We receive the same error for
all seven reports "The Microsoft Office Access database engine could not
find the object '0'. Make sure the object exists and that you spell its name
and the path name correctly." Please note that all of the forms and
sub-forms work from the Office 2007 computers. Here is the code behind on of
the buttons to run a report:
Private Sub Overdue_Workorders_Report_Click()
On Error GoTo Err_Overdue_Workorders_Report_Click
'opens overdue workorder report
Dim stDocName As String
stDocName = "OverDue Workorders Report"
DoCmd.OpenReport stDocName, acViewPreview, acViewNormal
Exit_Overdue_Workorders_Report_Click:
Exit Sub
Err_Overdue_Workorders_Report_Click:
MsgBox Err.Description
Resume Exit_Overdue_Workorders_Report_Click
End Sub
Any thoughts?
haven't found a suitable one.
I developed a Customer Support Database in Access 2003 where two users
in our office use it daily. The database has been split and both users have
Access 2003 installed on their computers. They have no problems running any
of the reports. There are two users (myself included) who have Office 2007
installed - one on Windows XP and one on Vista. Neither of us using Office
2007 can run the reports from the database. We receive the same error for
all seven reports "The Microsoft Office Access database engine could not
find the object '0'. Make sure the object exists and that you spell its name
and the path name correctly." Please note that all of the forms and
sub-forms work from the Office 2007 computers. Here is the code behind on of
the buttons to run a report:
Private Sub Overdue_Workorders_Report_Click()
On Error GoTo Err_Overdue_Workorders_Report_Click
'opens overdue workorder report
Dim stDocName As String
stDocName = "OverDue Workorders Report"
DoCmd.OpenReport stDocName, acViewPreview, acViewNormal
Exit_Overdue_Workorders_Report_Click:
Exit Sub
Err_Overdue_Workorders_Report_Click:
MsgBox Err.Description
Resume Exit_Overdue_Workorders_Report_Click
End Sub
Any thoughts?