Using Query Edit in a Form Textbox (or Table Field)

[Dominic Vella]

Is it possible?

I want to store various SQL Statements in a table.

Is it possible from a form to call up the Query editor, then, after the
query editing had been finished with, to load the SQL statement into one of
the text boxes? I don't actually want to save it as a MS-Access Query.

Thanks in Advance.


Dom

 

[Douglas J. Steele]

I don't believe it's possible.

 

[a a r o n _ k e m p f]

well you could save it as an access query (come up with some unique
name) and then delete it

yah of course you can put a sql statement in a table.
you should use VB to get the QryDef and then jam it into a table

 

[Dominic Vella]

Yes, that was at the back of my mind, only it's hard to prevent the user
from renaming the query, and even more importantly, it's harder to note when
the query has been closed.

Thanks for the head's up in any case.


Dom

well you could save it as an access query (come up with some unique
name) and then delete it

yah of course you can put a sql statement in a table.
you should use VB to get the QryDef and then jam it into a table