Loop through report objects

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SHIPP - 15 Mar 2005 16:01 GMT

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?

Signature

M. Shipp

Reply to this Message

Allen Browne - 15 Mar 2005 16:09 GMT

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.
Tips for Access users - http://allenbrowne.com/tips.html
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?

Reply to this Message

SHIPP - 15 Mar 2005 17:25 GMT

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?
>
[quoted text clipped - 10 lines]
> > 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?

Reply to this Message

Allen Browne - 15 Mar 2005 17:43 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
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
[quoted text clipped - 12 lines]
>> > name
>> > and description to an access table in the same database?

Reply to this Message