Query objects

  • Thread starter Thread starter Irine
  • Start date Start date
I

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
 
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.
 
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.
.
 
Back
Top