Query objects

[Irine]

Is there a way I can query my query objects. I want to
get a list of all the queries in my database.

I really appreciate any help you provide.

Thanks,
Irine

 

[fredg]

Is there a way I can query my query objects. I want to
get a list of all the queries in my database.

I really appreciate any help you provide.

Thanks,
Irine

SELECT MSysObjects.Name FROM MSysObjects WHERE
(((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5)) ORDER BY
MSysObjects.Name;

If you wish to show the list in a Combo/List box simply use the above
as it's RowSource.

 

[Irine]

Hi Fred,
Thank you for the info. This query makes my life easier
comparing objects between two Access application.
You're the best.

My best regards,
Irine

-----Original Message-----

Is there a way I can query my query objects. I want to
get a list of all the queries in my database.

I really appreciate any help you provide.

Thanks,
Irine

SELECT MSysObjects.Name FROM MSysObjects WHERE
(((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5)) ORDER BY
MSysObjects.Name;

If you wish to show the list in a Combo/List box simply use the above
as it's RowSource.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.