Query open in design view?

[Guest]

Is it possible to determine when a specific query is open in design view? Or
is it possible to determine when the query design window is open?

Any assistance is appreciated.

 

[Guest]

Hi,

I have a solution in the lateste versions of access you have the currentdata
object.

CurrentData.AllQueries(0).CurrentView

will give you respectively the status in which the query is. And will throw
an error if it's not opened.

 

[Guest]

JaRa,

Thank you so much for your reply. I was unaware of this feature. It was
exactly what I was looking for.

Just for the record, the code I finally used was:
If CurrentData.AllQueries("QueryName").IsLoaded = True Then
Do something
Else
Do something else
End If

Thanks again for the suggestion.

Mr B

 

[Guest]

THis solution does not cover whether the query is in designview whereas
currentview makes a difference in these modi.

 

[Guest]

RaJa,

In my specific situation I do not necessarily need to determine if the query
is in design mode or not, just if it is loaded. However, I will be taking a
look at the "currentview" option.

Thanks again.

Mr B