G
Guest
I have a rather large union query I build through code, then I *wanted* to
use the SQL string as the record source for a display form. I ran into a
problem that the string was too long (seems that you can only put a SQL
statement of up to about 2000 characters into a forms Recordsource)...
So the next idea is to try and save the string as a query (I did save one
try of the process as a query, and used the Form Wizard to create the display
form). Just not having luck finding any hints on how to do this.
Can you save a new query (preferably overwrite the query name) on the fly
like this? Appreciate some pointers.
BTW, this is a HUGE string, pretty near 16,000 character for the iteration I
just ran...it could possibly become larger.
Thanks!
use the SQL string as the record source for a display form. I ran into a
problem that the string was too long (seems that you can only put a SQL
statement of up to about 2000 characters into a forms Recordsource)...
So the next idea is to try and save the string as a query (I did save one
try of the process as a query, and used the Form Wizard to create the display
form). Just not having luck finding any hints on how to do this.
Can you save a new query (preferably overwrite the query name) on the fly
like this? Appreciate some pointers.
BTW, this is a HUGE string, pretty near 16,000 character for the iteration I
just ran...it could possibly become larger.
Thanks!