Convert Query SQL to VBA Code in Microsoft Access. Add Line Breaks, Quotes, vbNewLine, and More.
25.2 هزار بار بازدید -
4 سال پیش
-
Do you copy a lot
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:
Convert Query SQL to VBA Code in Micr...
BECOME A MEMBER:
@599cd
LINKS:
Replace Function: https://599cd.com/Replace
Me.RecordSource: https://599cd.com/RecordSource
Double Double Quotes: https://599cd.com/DoubleDouble
SetFocus: https://599cd.com/SetFocus
Intro to VBA: https://599cd.com/IntroVBA
ADDITIONAL RESOURCES:
Get on my Mailing List: https://599cd.com/YTML
FREE Access Beginner Level 1: https://599cd.com/Free1
FREE Blank Customer Template: https://599cd.com/FRL2
$1 Access Level 2: https://599cd.com/1Dollar
TechHelp: https://599cd.com/TechHelp
Twitter: Twitter: LearningAccess
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
Email Me: [email protected]
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.
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:
Convert Query SQL to VBA Code in Micr...
BECOME A MEMBER:
@599cd
LINKS:
Replace Function: https://599cd.com/Replace
Me.RecordSource: https://599cd.com/RecordSource
Double Double Quotes: https://599cd.com/DoubleDouble
SetFocus: https://599cd.com/SetFocus
Intro to VBA: https://599cd.com/IntroVBA
ADDITIONAL RESOURCES:
Get on my Mailing List: https://599cd.com/YTML
FREE Access Beginner Level 1: https://599cd.com/Free1
FREE Blank Customer Template: https://599cd.com/FRL2
$1 Access Level 2: https://599cd.com/1Dollar
TechHelp: https://599cd.com/TechHelp
Twitter: Twitter: LearningAccess
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
Email Me: [email protected]
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.
4 سال پیش
در تاریخ 1399/10/11 منتشر شده
است.
25,235
بـار بازدید شده