Loop through report objects

[Guest]

Is there a way to loop through all the report objects and write their name
and description to an access table in the same database?

 

[Allen Browne]

Yes, but why?

Access already has a list of all the reports in a table. You can query it
with:
SELECT [Name] FROM MsysObjects
WHERE (([Type] = -32764) AND ([Name] Not Like "~*") AND ([Name] Not Like
"MSys*"))
ORDER BY [Name];--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

 

[Guest]

Thanks a lot. That's perfect. Are there other values to look at other objects
such as queries, tables, modules, macros, etc?

Yes, but why?

Access already has a list of all the reports in a table. You can query it
with:
SELECT [Name] FROM MsysObjects
WHERE (([Type] = -32764) AND ([Name] Not Like "~*") AND ([Name] Not Like
"MSys*"))
ORDER BY [Name];--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Is there a way to loop through all the report objects and write their name
and description to an access table in the same database?

 

[Allen Browne]

The Type is:
1 for tables;
6 for linked tables;
4 for ODBC linked tables;
5 for queries;
-32768 for forms;
-32761 for modules.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thanks a lot. That's perfect. Are there other values to look at other
objects
such as queries, tables, modules, macros, etc?

Yes, but why?

Access already has a list of all the reports in a table. You can query it
with:
SELECT [Name] FROM MsysObjects
WHERE (([Type] = -32764) AND ([Name] Not Like "~*") AND ([Name] Not Like
"MSys*"))
ORDER BY [Name];

Is there a way to loop through all the report objects and write their
name
and description to an access table in the same database?