name of all reports

[hakeem777 via AccessMonster.com]

I am using access 97 and how do I get all the names of report by macro or vb
code? Thanks.

 

[Allen Browne]

Here you go:
SELECT MSysObjects.Name
FROM MSysObjects
WHERE MSysObjects.Type = -32764
ORDER BY MSysObjects.Name;

As you found, you can't use the AllReports collection in Access 97.

 

[Allen Browne]

Here's further details, showing a couple of ways to get the names of reports
into a list box:
http://allenbrowne.com/ser-19.html