Save SqlString as a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sandy - 28 Sep 2006 19:46 GMT

I am generating a SqlString based on various inputs and want to do a SAVE AS
to save the final SqlString as a query. I will use this as a sub query to
generate a scatter plot. My sub query would be named Q_Sub

I will need to overwrite the Q_Sub query each time I run it.

I then need a line of code that will update the chart with the Main query --
Q_Main -- instead of the SqlString, ie replace Me.Graph0.RowSource =
SqlString with something like Me.Graph0.RowSource = Q_Main

Thanks!
sandy

Reply to this Message

Duane Hookom - 28 Sep 2006 20:25 GMT

Not sure what exactly you are attempting to accomplish but you can change
the SQL of a saved query with a little DAO code.

CurrentDb.QueryDefs("qselYourName").SQL = strYourSqlString

Signature

Duane Hookom
MS Access MVP

>I am generating a SqlString based on various inputs and want to do a SAVE
>AS
[quoted text clipped - 10 lines]
> Thanks!
> sandy

Reply to this Message