converting a sql statement

  • Thread starter Thread starter Southern at Heart
  • Start date Start date
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.
 
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
..
 
Back
Top