{"id":249,"date":"2015-12-15T16:27:01","date_gmt":"2015-12-15T21:27:01","guid":{"rendered":"http:\/\/access-diva.com\/blog\/?p=249"},"modified":"2016-07-08T21:03:31","modified_gmt":"2016-07-09T01:03:31","slug":"procedure-view-vs-full-module-view","status":"publish","type":"post","link":"https:\/\/access-diva.com\/blog\/?p=249","title":{"rendered":"Procedure View vs. Full Module View"},"content":{"rendered":"<p>While developing you may find yourself in the VB Editor adjusting the Function for a Control or the Form itself.\u00a0 When it opens you have to hunt down where the cursor is flashing, even though you have clicked the After_Update event for a specific control.\u00a0 There\u2019s an easier way\u2026<\/p>\n<ol>\n<li>When you click the Build button on the event line for which you want to modify\u2026<\/li>\n<\/ol>\n<div id=\"attachment_250\" style=\"width: 358px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-250\" class=\"wp-image-250 size-full\" src=\"http:\/\/access-diva.com\/blog\/wp-content\/uploads\/2015\/12\/2015-12-10_14-05-10.png\" alt=\"Step 1\" width=\"348\" height=\"375\" srcset=\"https:\/\/access-diva.com\/blog\/wp-content\/uploads\/2015\/12\/2015-12-10_14-05-10.png 348w, https:\/\/access-diva.com\/blog\/wp-content\/uploads\/2015\/12\/2015-12-10_14-05-10-278x300.png 278w, https:\/\/access-diva.com\/blog\/wp-content\/uploads\/2015\/12\/2015-12-10_14-05-10-139x150.png 139w\" sizes=\"auto, (max-width: 348px) 100vw, 348px\" \/><p id=\"caption-attachment-250\" class=\"wp-caption-text\">Step 1<\/p><\/div>\n<p>&nbsp;<\/p>\n<p style=\"padding-left: 30px;\">2.\u00a0 The VB Editor opens and you see the entire VB Editor.\u00a0 Rather than hunt down where the cursor is flashing\u2026<\/p>\n<div id=\"attachment_251\" style=\"width: 246px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-251\" class=\"wp-image-251 size-full\" src=\"http:\/\/access-diva.com\/blog\/wp-content\/uploads\/2015\/12\/2015-12-10_13-56-33.png\" alt=\"Step 2\" width=\"236\" height=\"952\" srcset=\"https:\/\/access-diva.com\/blog\/wp-content\/uploads\/2015\/12\/2015-12-10_13-56-33.png 236w, https:\/\/access-diva.com\/blog\/wp-content\/uploads\/2015\/12\/2015-12-10_13-56-33-74x300.png 74w, https:\/\/access-diva.com\/blog\/wp-content\/uploads\/2015\/12\/2015-12-10_13-56-33-37x150.png 37w\" sizes=\"auto, (max-width: 236px) 100vw, 236px\" \/><p id=\"caption-attachment-251\" class=\"wp-caption-text\">Step 2<\/p><\/div>\n<p style=\"padding-left: 30px;\">3.\u00a0 \u2026select the Procedure View button located in the lower left hand corner of the VB Editor (see image below, Step 3).<\/p>\n<div id=\"attachment_252\" style=\"width: 246px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-252\" class=\"wp-image-252 size-full\" src=\"http:\/\/access-diva.com\/blog\/wp-content\/uploads\/2015\/12\/2015-12-10_14-00-17.png\" alt=\"Step 3\" width=\"236\" height=\"532\" srcset=\"https:\/\/access-diva.com\/blog\/wp-content\/uploads\/2015\/12\/2015-12-10_14-00-17.png 236w, https:\/\/access-diva.com\/blog\/wp-content\/uploads\/2015\/12\/2015-12-10_14-00-17-133x300.png 133w, https:\/\/access-diva.com\/blog\/wp-content\/uploads\/2015\/12\/2015-12-10_14-00-17-67x150.png 67w\" sizes=\"auto, (max-width: 236px) 100vw, 236px\" \/><p id=\"caption-attachment-252\" class=\"wp-caption-text\">Step 3<\/p><\/div>\n<p>Now you&#8217;re only going to see the Procedure for the Control you selected!\u00a0 Pretty cool!<\/p>\n<p><span style=\"color: #000000; font-family: Segoe UI; font-size: small;\">\u00a0<\/span><\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_249\" class=\"pvc_stats all  \" data-element-id=\"249\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/access-diva.com\/blog\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>While developing you may find yourself in the VB Editor adjusting the Function for a Control or the Form itself. When it opens you have to hunt down where the cursor is flashing, even though you have clicked the After_Update event for a specific control. There\u2019s an easier way\u2026<\/p>\n<p> When you click the Build button [&#8230;]<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_249\" class=\"pvc_stats all  \" data-element-id=\"249\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/access-diva.com\/blog\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[84,20,85,76],"class_list":["post-249","post","type-post","status-publish","format-standard","hentry","category-access-tips","tag-database-design","tag-forms","tag-vb-editor","tag-vba","odd"],"_links":{"self":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/249","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=249"}],"version-history":[{"count":2,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/249\/revisions"}],"predecessor-version":[{"id":384,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/249\/revisions\/384"}],"wp:attachment":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}