{"id":241,"date":"2015-11-12T00:12:35","date_gmt":"2015-11-12T05:12:35","guid":{"rendered":"http:\/\/access-diva.com\/blog\/?p=241"},"modified":"2016-08-13T17:57:45","modified_gmt":"2016-08-13T21:57:45","slug":"sql-to-vba","status":"publish","type":"post","link":"https:\/\/access-diva.com\/blog\/?p=241","title":{"rendered":"SQL to VBA"},"content":{"rendered":"

Recently, I saw a post regarding moving a Query (SQL) to VBA.\u00a0 I remember I saw something somewhere that automated this task but could not remember where.\u00a0 Well, after a little surfing of my favorite sites I found it… Copy SQL statement from query to VBA<\/a>\u00a0by Allen Browne<\/a>.\u00a0 And, because I couldn’t leave well enough alone, I created the database following the steps listed and, for fun,\u00a0added a *Copy to Clipboard* button just so you can now click the button and paste, with Ctrl+V, right into the VB Editor…<\/p>\n

\"SQLtoVBA\"<\/p>\n

…and you can download it here<\/a>.<\/p>\n

Note<\/span>: The SQL cannot be used as RowSource for any Control or RecordSource for any Form.<\/p>\n

11.13.2015 \u00a0Amended so you can now also convert INSERT, DELETE and UPDATE queries as well.\u00a0 Enjoy!<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

Recently, I saw a post regarding moving a Query (SQL) to VBA. I remember I saw something somewhere that automated this task but could not remember where. Well, after a little surfing of my favorite sites I found it… Copy SQL statement from query to VBA by Allen Browne. And, because I couldn’t leave well […]<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,41],"tags":[18,82,76],"class_list":["post-241","post","type-post","status-publish","format-standard","hentry","category-access-tips","category-vba","tag-queries","tag-sql","tag-vba","odd"],"_links":{"self":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/241","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=241"}],"version-history":[{"count":5,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/241\/revisions"}],"predecessor-version":[{"id":422,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/241\/revisions\/422"}],"wp:attachment":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=241"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}