By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,297 Members | 1,383 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,297 IT Pros & Developers. It's quick & easy.

Keeping track of which queries are open

P: n/a
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.
Feb 14 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Feb 14, 10:36 am, Corrin <clarkso...@gmail.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
Feb 14 '08 #2

P: n/a
Try:
CurrentData.AllQueries("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" <cl********@gmail.comwrote in message
news:96**********************************@v4g2000h sf.googlegroups.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.
Feb 14 '08 #3

P: n/a
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.

Feb 14 '08 #4

P: n/a
On Feb 15, 8:14 am, Corrin <clarkso...@gmail.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!
Feb 18 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.