About this tutorial:
Video duration: 00:21:00
Do you copy a lot of SQL from the query designer SQL view over to the VBA editor to use in your code, and you spend a lot of time “fixing” the string, adding line continuation characters, adding quotes, etc. Well, in this video we’ll make a little utility you can use to perform that task with one click. You can use this in a RunSQL statement or a Me.RecordSource change.
LEVEL: Developer (SQL and VBA coding)
John from Hancock, New Hampshire (a Silver Member) asks: Is there a way to format the SQL text of a query with the proper line breaks and quotes so I can copy it to my VBA editor for…