Report Names

[aziz rasul]

I need to copy the names of hundreds of MS Access report names into a spreadsheet. I have tried to use a report count in order to go thru a loop extracting the report names. However I get 0 when I use

Dim intReports As Integer

intReports = Reports.Count

Can anyone c what is wrong here?

 

[alastair69]

Try this link it may help you out.

 

[aziz rasul]

That gave me what I wanted. Thanks.

Any idea why my code didn't work? Just curious.

 

[DB7]

You have to open the reports collection first, before accessing its properties.

Dim db As Database
Set db = CurrentDb
intReports = db.AllReports.Count

 

[DB7]

oops, a little rusty there....

intReports = CurrentProject.AllReports.Count