Problem access report - DBName can't find the object '.'
I'm trying to troubleshoot a custom built access database, built by an IT staff member who is no longer with us. The problem occurs when you hit a button that (I assume) is supposed to runs a report. When you hit the button, it prompts (DBName in replacement of actual database name): DBName can't find the object '.'
When I take a look at the access objects, there is a report that I am assuming is the report that it should be running, and when I attempt to launch it. The same message is displayed, with the addition " If '' is a new macro or macro group, make sure you have saved it and that you have typed it's name correctly."
I've looked at that report in design view, and there isn't any "on load" events or anything that I can see.
I have tested with access 2003 and 2007, with errors in both cases. This is a self contained .mdb
Anyone have ideas on what else I can look at?
When I take a look at the access objects, there is a report that I am assuming is the report that it should be running, and when I attempt to launch it. The same message is displayed, with the addition " If '' is a new macro or macro group, make sure you have saved it and that you have typed it's name correctly."
I've looked at that report in design view, and there isn't any "on load" events or anything that I can see.
I have tested with access 2003 and 2007, with errors in both cases. This is a self contained .mdb
Anyone have ideas on what else I can look at?
ASKER
Yes, it lists the report I was attempting to run manually. Here's the chunk related to that buttons event.
Private Sub cmdQuanties_CostReport_Click()
On Error GoTo Err_cmdQuanties_CostReport_Click
Dim stDocName As String
stDocName = "RptToDateQuantities"
DoCmd.OpenReport stDocName, acPreview
Exit_cmdQuanties_CostReport_Click:
Exit Sub
Err_cmdQuanties_CostReport_Click:
MsgBox Err.Description
Resume Exit_cmdQuanties_CostReport_Click
End Sub
As JDettman said, you need to see if there is a report "RptToDateQuantities" Listed in the db, then check the record source property of the report. That may point you in the right direction.
Yes, as DockieBoy has said, first verify the reports recordsource. Open the report in design view, goto the properties sheet and look on the data tab.
Then try to open that table/query.
There are a few things that could be wrong:
1. Linked tables are in the wrong place.
2. Code that creates tables for the report is not executing properly
3. The report was never finished
4. The DB is corrupt and has lost track of objects that it contained.
JimD.
ASKER
Sorry for slow reply, had a 3 day weekend thanks to Prsidents' Day.
Thank your for your help, you're defiantly getting me going in the right direction. The query runs fine and outputs data, so I think that must mean the data exists and is "proper" but something must be wrong with the report that is generated using this data?
Thank your for your help, you're defiantly getting me going in the right direction. The query runs fine and outputs data, so I think that must mean the data exists and is "proper" but something must be wrong with the report that is generated using this data?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry for taking so long to get back to you, but can you upload the db?
ASKER
I cannot provide the database, as it has private customer information. I still have not had time to continue the troubleshooting process, but I will soon. I appreciate the guidance and will finish this up soon.
ASKER
Thank you for your help in understanding this.
Open the form that the button is on in design view, right click on the button, select properties. Under the event tab, find the OnClick procedure and then hit the build button off to the right (...).
Look through the code and look for a DoCmd.OpenReport.
Then see if the named report is in the database.
JimD.