Dynamic List of Queries 1

[wally1169]

Is there a way to create a dynamic list of queries in a database to be called from say a combo box? I'm trying to create a form that launches queries, but that I don't have to update every time I create a new query.

Any help on this would be greatly appreciated.

Wally Bahny

 

[GGleason]

You should be able to do this with a timer in your form to refresh your query. I have not use timers in VBA, so I can't help there.

hth,
GGleason

 

[FancyPrairie]

Here's a query that will do it for you. Set your rowsource of your combobox to it.

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

 

[wally1169]

Thanks FancyPrairie, that's exactly what I needed, and it works!

Wally Bahny