converting a sql statement

[Southern at Heart]

I once saw some code you pasted on a form, the form would allow you to copy
your query sql into one textbox, and click a command button and presto, it
create something like:
strsql="text here"
which was ready for vba
anyone know where I could get this?
thanks.

 

[TonyT]

Here's one;

http://www.utteraccess.com/forums/showflat.php?Cat=&Board=48&Number=1165308

I haven't tried it, but it says it does what you want. Try googling "convert
SQL to vba"

TonyT..

 

[John Spencer]

This might help:
Copy SQL statement from query to VBA
at:
http://allenbrowne.com/ser-71.html

That's what I use.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..