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 a RunSQL command without doing all that manual editing?
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to a 30 MINUTE EXTENDED CUT of this video which walks you through some additional modifications to the utility, including splitting long lines up, loading a listbox with all of the queries in the database, and one-click to copy the SQL to the editor textbox and convert it.
MEMBERS ONLY VIDEO:
[ Ссылка ]
BECOME A MEMBER:
[ Ссылка ]
LINKS:
Replace Function: [ Ссылка ]
Me.RecordSource: [ Ссылка ]
Double Double Quotes: [ Ссылка ]
SetFocus: [ Ссылка ]
Intro to VBA: [ Ссылка ]
ADDITIONAL RESOURCES:
Get on my Mailing List: [ Ссылка ]
FREE Access Beginner Level 1: [ Ссылка ]
FREE Blank Customer Template: [ Ссылка ]
$1 Access Level 2: [ Ссылка ]
TechHelp: [ Ссылка ]
Twitter: [ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
Email Me: amicron@gmail.com
WHAT DOES LEVEL MEAN:
My Access classes are divided into multiple levels. BEGINNER requires little working knowledge of Access. EXPERT assumes you know relationships and how to use functions. ADVANCED users know macros and events. DEVELOPER uses SQL and/or VBA programming.
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, line breaks, vbnewline, vbtab, sql to vba, convert sql, convert to vba, line continuation character, runsql, recordsource, setfocus, copy to clipboard
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
