converting a sql statement

S

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.
 
J

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
..
 
Top