Runtime error 29068

[deesheeha]

Hello all!

Hope you can help me out. I have the following line of code:

DoCmd.Rename "rpt_RedLetter_Collection_IRL", acReport, "rpt_RedLetter_Collection_Active"

Everytime the code hits this report i get the following error:

Run-time error '29068' Microsoft Access cannot complete this operation. You must stop the code and try again.

Now if I go into my reports and manually open the report and close it and rerun the code it works fine!!!

Anyone any ideas??

Thanks
Dee

 

[Remou]

Have you tried a decompile? That can often fix odd errors.

 

[deesheeha]

Yeah, no luck!

 

[TheAceMan1]

How are ya deesheeha . . .

Is the report closed at the time the error occurs?

I can't say why the error occurs, but the following less direct method should work:

[blue][green]'Select the report in the Db Window[/green]
docmd.SelectObject acReport, "rpt_RedLetter_Collection_Active", True

[green]'Rename the currently selected object[/green]
docmd.Rename "rpt_RedLetter_Collection_IRL"[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[deesheeha]

Grrrrr, no that didnt work either!!! Starting to pull my hair out... Any other ideas?? Thanks for all your help so far!!

 

[PHV]

And what about this ?
CurrentProject.AllReports("rpt_RedLetter_Collection_IRL").Name = "rpt_RedLetter_Collection_Active"


Hope This Helps, PH.
FAQ219-2884
FAQ181-2886