Convert Query SQL to VBA Code in Microsoft Access. Add Line Breaks, Quotes, vbNewLine, and More.




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…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads