Query objects

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
 
F

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
Click to expand...

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.
 
I

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
Click to expand...

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.
.
Click to expand...
 
Top