Keeping track of which queries are open

[Corrin]

Hi,

I'm looking for a way to check if a specific query is currently open.
This seems like something that should be an application or database
property, but I can't seem to find it anywhere.

Any help would be appreciated.

[Darragh]

Re: Keeping track of which queries are open

On Feb 14, 10:36 am, Corrin <clarkso...@gma il.comwrote:

Hi,
>
I'm looking for a way to check if a specific query is currently open.
This seems like something that should be an application or database
property, but I can't seem to find it anywhere.
>
Any help would be appreciated.

Hi Corrin.

If you're familiar with VBA, then the function talked about in the
following link may help.

http://msdn2.microsoft.com/en-us/library/bb243768.aspx

Function name is isObjectLoaded.

regards
Darragh

[Allen Browne]

Re: Keeping track of which queries are open

Try:
CurrentData.All Queries("Query1 ").IsLoaded
using your own query name instead of Query1.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Corrin" <clarkson.c@gma il.comwrote in message
news:967305b3-6e38-4056-875f-1ec0a1b22e7c@v4 g2000hsf.google groups.com...

>
I'm looking for a way to check if a specific query is currently open.
This seems like something that should be an application or database
property, but I can't seem to find it anywhere.
>
Any help would be appreciated.

[Corrin]

Re: Keeping track of which queries are open

Thanks for the help.

I ended up using Allen's solution as it fit well with my existing
code.
Also Allen I found this forum through your site, so thanks for linking
to it.

[Darragh]

Re: Keeping track of which queries are open

On Feb 15, 8:14 am, Corrin <clarkso...@gma il.comwrote:

Thanks for the help.
>
I ended up using Allen's solution as it fit well with my existing
code.
Also Allen I found this forum through your site, so thanks for linking
to it.

Hehe, thats ok! Allen's solution was much better!