Object library feature not supported!

[TheCronus]

Hi, i have been delegated a work. There are one MDB and one MDE file, which had been developed on Office XP. Clients are using the MDE file.

On my computer, on which Win2K is runnig with Office XP installed, both original files are functioning right.

In the code, the previous developer had done such a thing;

Dim myReport As Report
Set myReport = Reports!customer_invoice_report

And dynamically changed the source of the report by

myReport.RecordSource = newSQL

I have made a change in newSQL and saved the code. However, when i ran the form, entered the criteria and pressed the REPORT button (which loads the report), i got an complie error on the line "Set myReport = Reports!customer_invoice_report;

"Object library feature not supported."

I could not resolve why. Original files are running well but the one on which i made the change is getting the error.

Can anyone guess why this can happen?

I wanna also add that, in the form code, I can see the properties and methods of the "myReport" object when I put the dot afetr the object. This one also makes me confused. In the references, "Microsoft Access 10.0 Object Library" is present.

Thx a lot in advance for your help.

 

[Liv Manto]

Can you paste the old and NEW SQL?

 

[TheCronus]

Hi

No, i have not forgotten. But I could not realize that those problems were related with other.

By the way, I set up a fresh system and tried what I have done before, and it all worked, even modifying the record source before opening the report.

How confusing!!!

But I will do as u mentioned in the other thread. Thx Pat Hartman.