Vba to sql string converter

[mahmed1]

Hi

Often i am creating some SQL string in access and then i use this in my vba code...

I have found this link that helps me convert my sql string to vba

Total Visual CodeTools: Long Text SQL Builder

Convert text and SQL strings to variable assignments with wordwrapping and quote conversions in Microsoft Access, Office, VBA, VB6

www.fmsinc.com

Is there any links or functions anyone cam help me with which takes the vba string and puts it back to and SQL statement as if i need to change the SQL and i need to test in access - Im having to copy the vba sql string and then remove all the speech marks, & _etc to allow me to be able to run in access

Any help to quickly allow me to switch the codes would be really useful

thank u

 

[welshgasman]

I have used this in the past.
Mendip Data Systems

HTH

 

[mahmed1]

Thank you - will save me loads of time

thank you