string syntax

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there something wrong with this line? strSQL is a string

strSQL = CurrentDb.QueryDefs("pqQuickSearch").SQL

Error is "property not supported"
 
I think it has something to do with the connection string being open or
closed. Is there a way to determine if the connection is open that I could
display in a msgbox? The line to open the connection immediately precedes
this. I don't get the error when I close and re-open the app. But the 2nd
time through the error occurs.
 
smk23 said:
Is there something wrong with this line? strSQL is a string

strSQL = CurrentDb.QueryDefs("pqQuickSearch").SQL

Error is "property not supported"
Click to expand...

Looks fine to me, and it works in my database with my query. Are you
sure that's the line that's raising the error?
 
smk23 said:
I think it has something to do with the connection string being open
or closed. Is there a way to determine if the connection is open that
I could display in a msgbox? The line to open the connection
immediately precedes this. I don't get the error when I close and
re-open the app. But the 2nd time through the error occurs.
Click to expand...

What connection string? Where does a connect string come into this?

Maybe you'd better show the surrounding code and give some background.
 
that's actually very helpful because I know to move on. That line isn't the
problem. Appreciate it. Will post back when I have an intelligent question.
Thanks
 
Back
Top