List Queries in a Combo or List Box

[stormking]

I am trying to put a list of my queries in a combo box so it will list all queries when new queries are added. I can only seem to get the records in a specific query or table, how do I get the list of queries to be listed in the box?
Any SQL or VBA code if needed would be helpful.
Thank you.

Wendy

 

[montrose]

http://www.fabalou.com/Access/Forms/reportslist.htm

has sample code to do this with reports. Can substitute for qrys, especially using System Objects reference. HTH.

 

[stormking]

Thank you for the link. I will try this and let you know how this project is going. WSS

 

[stormking]

I have not been able to get the code you pointed me to to work. I keep getting compile errors "expected user-defined type, not project." I had put Access in for Dim Dbs as Database (Database is not an option). Any suggestions?

Thanks

 

[montrose]

Don't know what the problem is there. Try this instead. In the Row Source for your combo box, put

SELECT msysobjects.Name FROM msysobjects WHERE (((msysobjects.Type)=5));


You should then be able to see your list of queries.

 

[stormking]

Thank you Montrose.

The new SQL code worked and brought my queries into my combobox.

Thanks, I may be back while this project continues on. It is getting more involved that I first thought.

Thanks again. wss

 

[montrose]

You're welcome. Glad that worked for you.