Rename report in access vba

[cdlaforc]

Hello,
Can someone tell me how to rename a report in access with vba.
Thanks,

Chris.

 

[AlexCuse]

like this?

    Reports("OldName").Name = "New Name"

Hope it helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[cdlaforc]

When I do this I get the error that the report name is misspelled, doesn't exist, or isn't open. I copied the name of the report so I don't know why I'm getting this.
Thanks,

Chris.

 

[TheAceMan1]

How are ya cdlaforc . . .

Have a look at the [blue]DoCmd.ReName[/blue] method! . . .

See Ya! . . . . . .

 

[cdlaforc]

Thanks everyone I actually got it to work a little differently. What I was doing is querying a table with records for a bunch of different departments at work so I was looping through the departments and I wanted to rename the report and then print it to my adobe writer and name it back, then do it again. A guy at work just suggested to write it out and then use the Name method to rename the file at that point. It worked fine, but again thanks for the help.
Thanks,


Chris.