{"id":6895,"date":"2013-04-12T16:01:28","date_gmt":"2013-04-12T07:01:28","guid":{"rendered":"http:\/\/vicpress.dip.jp\/?p=6895"},"modified":"2013-04-12T16:11:01","modified_gmt":"2013-04-12T07:11:01","slug":"acces%e3%81%ae%e3%83%95%e3%82%a9%e3%83%bc%e3%83%a0%e3%81%a7%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%83%9c%e3%83%83%e3%82%af%e3%82%b9%e3%82%92%e8%87%aa%e5%8b%95%e7%9a%84%e3%81%aboff%e3%82%8b%e3%82%af","status":"publish","type":"post","link":"https:\/\/vicpress.net\/?p=6895","title":{"rendered":"\u66f4\u65b0\u30af\u30a8\u30ea\u3067ACCES\u30d5\u30a9\u30fc\u30e0\u306e\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9OFF\u9ad8\u901f\u5316"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>\u6700\u8fd1\u3001PP\u3084\u8eca\u306e\u8a71\u984c\u3070\u304b\u308a\u3067\u30db\u30f3\u30c8\u306b\u4ed5\u4e8b\u3057\u3066\u3093\u306e\uff1f\u3063\u3066\u611f\u3058\u306a\u3093\u3067\u3001\u3061\u3087\u3063\u3068\u304a\u4ed5\u4e8b\u306e\u304a\u8a71\u3057\u3092\u3002\u3002\uff57<\/p>\n<p>&nbsp;<\/p>\n<p>\u4ee5\u524d\u3001ACCESS2007\u306e\u30d5\u30a9\u30fc\u30e0\u3067\u30b5\u30d6\u30d5\u30a9\u30fc\u30e0\u306b\u62bd\u51fa\u3057\u305f\u30c7\u30fc\u30bf\u306e\u4e2d\u304b\u3089\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u306b\u30c1\u30a7\u30c3\u30af\u3057\u305f\u884c\u3060\u3051\u3092\u5370\u5237\uff08\u30d7\u30ec\u30d3\u30e5\u30fc\u8868\u793a\uff09\u3057\u3001\u305d\u306e\u5f8c\u30c1\u30a7\u30c3\u30af\u3092\u81ea\u52d5\u7684\u306bOFF\u306b\u3059\u308bVBA\u3092\u4f5c\u3063\u305f\u3093\u3067\u3059\u304c\u3001\u3001<\/p>\n<p>\u30b5\u30d6\u30d5\u30a9\u30fc\u30e0\u306b\u62bd\u51fa\u3055\u308c\u305f\u30c7\u30fc\u30bf\u6570\u304c\u591a\u3044\u3068\u3001\u30c1\u30a7\u30c3\u30af\u30aa\u30d5\u306b\u7570\u5e38\u306b\u6642\u9593\u304c\u304b\u304b\u308b\u306e\u3067\u4f55\u3068\u304b\u3057\u3066\uff01\u3063\u3066\u983c\u307e\u308c\u307e\u3057\u305f\u3002<\/p>\n<p>\u5b9f\u969b\u3001\u30b5\u30d6\u30d5\u30a9\u30fc\u30e0\u306b\u62bd\u51fa\u3055\u308c\u305f\u884c\u6570\u3092\u7b97\u51fa\u3057\u3001\u30c1\u30a7\u30c3\u30af\u306e\u6709\u7121\u306b\u304b\u304b\u308f\u3089\u305a1\u884c\u76ee\u304b\u3089\u6700\u7d42\u884c\u307e\u3067\u30c1\u30a7\u30c3\u30af\u30aa\u30d5\u3092\u7e70\u308a\u8fd4\u3059VBA\u306e\u305f\u3081\u3001\u30c7\u30fc\u30bf\u91cf\u304c\u6570\u767e\u884c\u3068\u304b\u306b\u306a\u308b\u3068\u30c1\u30a7\u30c3\u30af\u30aa\u30d5\u306b\u304b\u306a\u308a\u6642\u9593\u304c\u304b\u304b\u308a\u307e\u3059\u3002<\/p>\n<p>\u306a\u3089\u3082\u3063\u3068\u6761\u4ef6\u3092\u7d5e\u308a\u8fbc\u3093\u3067\u304b\u3089\u62bd\u51fa\u3059\u308c\u3070\u30a4\u30a4\u3058\u3083\u3093\uff01<\/p>\n<p>\u30fb\u30fb\u30fb\u3063\u3066\u8a33\u306b\u3082\u3044\u304b\u306a\u3044\u3088\u3046\u3067\u3002\u3002\uff57<\/p>\n<p>&nbsp;<\/p>\n<p>\u305d\u3053\u3067\u3001VBA\u3067\u30c1\u30a7\u30c3\u30af\u30aa\u30d5\u3059\u308b\u306e\u3067\u306f\u306a\u304f\u3001\u66f4\u65b0\u30af\u30a8\u30ea\u3092\u4f7f\u3063\u3066\u307f\u308b\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u30b5\u30d6\u30d5\u30a9\u30fc\u30e0\u306e\u30bd\u30fc\u30b9\u306b\u306a\u3063\u3066\u3044\u308b\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u5370\u5237\u30c1\u30a7\u30c3\u30af\u30ab\u30e9\u30e0\u304c-1\uff08\u30c1\u30a7\u30c3\u30af\u30aa\u30f3\uff09\u306e\u3082\u306e\u3092\u62bd\u51fa\u3057\u3066-1\u30920\uff08\u30c1\u30a7\u30c3\u30af\u30aa\u30d5\uff09\u306b\u66f4\u65b0\u3059\u308b\u30af\u30a8\u30ea\u3067\u3059\u3002<\/p>\n<p>SQL\u3060\u3068\u3053\u3093\u306a\u611f\u3058\u3002<\/p>\n<p>UPDATE (\u30c6\u30fc\u30d6\u30eb\u540d) SET (\u30c6\u30fc\u30d6\u30eb\u540d).(\u5370\u5237\u30c1\u30a7\u30c3\u30af\u30ab\u30e9\u30e0\u540d) = 0<br \/>\nWHERE ((((\u30c6\u30fc\u30d6\u30eb\u540d).(\u5370\u5237\u30c1\u30a7\u30c3\u30af\u30ab\u30e9\u30e0\u540d))=-1));<\/p>\n<p>\u3053\u308c\u3092\u9069\u5f53\u306a\u540d\u524d\u3067\u4fdd\u5b58\u3057\u3066\u3001\u3042\u3068\u306f\u30d5\u30a9\u30fc\u30e0\u306e\u5370\u5237\u30dc\u30bf\u30f3\u306e\u30a4\u30d9\u30f3\u30c8\u306bVBA\u3067\u4ee5\u4e0b\u3092\u6307\u5b9a\u3059\u308b\u3060\u3051\u3067\u3059\u3002<\/p>\n<p>Dim stDocName As String<br \/>\nstDocName = &#8220;(\u30ec\u30dd\u30fc\u30c8\u540d)&#8221;<br \/>\nDoCmd.OpenReport stDocName, acPreview<\/p>\n<p>DoCmd.SetWarnings False<br \/>\nDoCmd.OpenQuery &#8220;(\u66f4\u65b0\u30af\u30a8\u30ea\u540d)&#8221;<br \/>\nMe!(\u30b5\u30d6\u30d5\u30a9\u30fc\u30e0\u540d).Requery<br \/>\nDoCmd.SetWarnings True<\/p>\n<p>\u30fb1\uff5e3\u884c\u76ee\uff1a\u30ec\u30dd\u30fc\u30c8\u3092\u6307\u5b9a\u3057\u3066\u30d7\u30ec\u30d3\u30e5\u30fc\u8868\u793a\u3055\u305b\u307e\u3059\u3002<br \/>\n\uff08\u30ec\u30dd\u30fc\u30c8\u306e\u30bd\u30fc\u30b9\u30af\u30a8\u30ea\u3067\u5370\u5237\u30c1\u30a7\u30c3\u30af\u30aa\u30f3\u306e\u30c7\u30fc\u30bf\u306e\u307f\u51fa\u529b\u306b\u8a2d\u5b9a\uff09<br \/>\n\u30fb4\u884c\u76ee\uff1a\u300cSetWarning False\u300d\u3067\u66f4\u65b0\u30af\u30a8\u30ea\u5b9f\u884c\u6642\u306e\u4f59\u8a08\u306a\u8b66\u544a\u304c\u51fa\u306a\u3044\u3088\u3046\u306b\u8b66\u544a\u8a2d\u5b9a\u3092\u30aa\u30d5\u306b\u3057\u307e\u3059\u3002<br \/>\n\u30fb5\u884c\u76ee\uff1a\u66f4\u65b0\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3002<br \/>\n\u30fb6\u884c\u76ee\uff1a\u30b5\u30d6\u30d5\u30a9\u30fc\u30e0\u3092\u30ea\u30af\u30a8\u30ea\u3057\u3066\u66f4\u65b0\u30af\u30a8\u30ea\u306e\u5b9f\u884c\u7d50\u679c\u3092\u30d5\u30a9\u30fc\u30e0\u306b\u53cd\u6620\u3055\u305b\u307e\u3059\u3002<br \/>\n\u30fb7\u884c\u76ee\uff1a\u300cSetWarning True\u300d\u3067\u8b66\u544a\u8a2d\u5b9a\u3092\u5143\u306b\u623b\u3057\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u3053\u306e\u66f4\u65b0\u30af\u30a8\u30ea\u3092\u4f7f\u3063\u3066\u307f\u305f\u3089\u3001\u30c1\u30a7\u30c3\u30af\u30aa\u30d5\u306e\u51e6\u7406\u304c\u5287\u7684\u306b\u901f\u304f\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n<p>\u62bd\u51fa\u3055\u308c\u305f\u30c7\u30fc\u30bf\u304c\u6570\u767e\u884c\u3042\u3063\u3066\u3082\u6570\u79d2\u3067\u30c1\u30a7\u30c3\u30af\u30aa\u30d5\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>\u30d5\u30a9\u30fc\u30e0\u4e0a\u306e\u30c7\u30fc\u30bf\u3092VBA\u3067\u76f4\u63a5\u66f4\u65b0\u3059\u308b\u3088\u308a\u3001\u30af\u30a8\u30ea\u3067\u66f4\u65b0\u3059\u308b\u65b9\u304c\u306f\u308b\u304b\u306b\u901f\u3044\u3093\u3067\u3059\u306d\u3002<\/p>\n<p>\u307e\u305f\u4e00\u3064\u52c9\u5f37\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<aside class=\"row veu_insertAds after\"><div class=\"col-md-12\"><script data-ad-client=\"ca-pub-1123445179682316\" async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><\/div><\/aside><div class=\"veu_socialSet veu_socialSet-position-after veu_contentAddSection\"><script>window.twttr=(function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0],t=window.twttr||{};if(d.getElementById(id))return t;js=d.createElement(s);js.id=id;js.src=\"https:\/\/platform.twitter.com\/widgets.js\";fjs.parentNode.insertBefore(js,fjs);t._e=[];t.ready=function(f){t._e.push(f);};return t;}(document,\"script\",\"twitter-wjs\"));<\/script><ul><li class=\"sb_facebook sb_icon\"><a class=\"sb_icon_inner\" href=\"\/\/www.facebook.com\/sharer.php?src=bm&u=https%3A%2F%2Fvicpress.net%2F%3Fp%3D6895&amp;t=VICPRESS\" target=\"_blank\" onclick=\"window.open(this.href,'FBwindow','width=650,height=450,menubar=no,toolbar=no,scrollbars=yes');return false;\"><span class=\"vk_icon_w_r_sns_fb icon_sns\"><\/span><span class=\"sns_txt\">Facebook<\/span><span class=\"veu_count_sns_fb\"><\/span><\/a><\/li><li class=\"sb_twitter sb_icon\"><a class=\"sb_icon_inner\" href=\"\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fvicpress.net%2F%3Fp%3D6895&amp;text=VICPRESS\" target=\"_blank\" ><span class=\"vk_icon_w_r_sns_twitter icon_sns\"><\/span><span class=\"sns_txt\">twitter<\/span><\/a><\/li><li class=\"sb_hatena sb_icon\"><a class=\"sb_icon_inner\" href=\"\/\/b.hatena.ne.jp\/add?mode=confirm&url=https%3A%2F%2Fvicpress.net%2F%3Fp%3D6895&amp;title=VICPRESS\" target=\"_blank\"  onclick=\"window.open(this.href,'Hatenawindow','width=650,height=450,menubar=no,toolbar=no,scrollbars=yes');return false;\"><span class=\"vk_icon_w_r_sns_hatena icon_sns\"><\/span><span class=\"sns_txt\">Hatena<\/span><span class=\"veu_count_sns_hb\"><\/span><\/a><\/li><li class=\"sb_pocket sb_icon\"><a class=\"sb_icon_inner\"  href=\"\/\/getpocket.com\/edit?url=https%3A%2F%2Fvicpress.net%2F%3Fp%3D6895&title=VICPRESS\" target=\"_blank\"  onclick=\"window.open(this.href,'Pokcetwindow','width=650,height=450,menubar=no,toolbar=no,scrollbars=yes');return false;\"><span class=\"vk_icon_w_r_sns_pocket icon_sns\"><\/span><span class=\"sns_txt\">Pocket<\/span><span class=\"veu_count_sns_pocket\"><\/span><\/a><\/li><li class=\"sb_copy sb_icon\"><button class=\"copy-button sb_icon_inner\"data-clipboard-text=\"VICPRESS https:\/\/vicpress.net\/?p=6895\"><span class=\"vk_icon_w_r_sns_copy icon_sns\"><i class=\"fas fa-copy\"><\/i><\/span><span class=\"sns_txt\">Copy<\/span><\/button><\/li><\/ul><\/div><!-- [ \/.socialSet ] -->","protected":false},"excerpt":{"rendered":"<p>&nbsp; \u6700\u8fd1\u3001PP\u3084\u8eca\u306e\u8a71\u984c\u3070\u304b\u308a\u3067\u30db\u30f3\u30c8\u306b\u4ed5\u4e8b\u3057\u3066\u3093\u306e\uff1f\u3063\u3066\u611f\u3058\u306a\u3093\u3067\u3001\u3061\u3087\u3063\u3068\u304a\u4ed5\u4e8b\u306e\u304a\u8a71\u3057\u3092\u3002\u3002\uff57 &nbsp; \u4ee5\u524d\u3001ACCESS2007\u306e\u30d5\u30a9\u30fc\u30e0\u3067\u30b5\u30d6\u30d5\u30a9\u30fc\u30e0\u306b\u62bd\u51fa\u3057\u305f\u30c7\u30fc\u30bf\u306e\u4e2d\u304b\u3089\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u306b\u30c1 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":"","vkexunit_cta_each_option":""},"categories":[5],"tags":[],"_links":{"self":[{"href":"https:\/\/vicpress.net\/index.php?rest_route=\/wp\/v2\/posts\/6895"}],"collection":[{"href":"https:\/\/vicpress.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vicpress.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vicpress.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vicpress.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6895"}],"version-history":[{"count":6,"href":"https:\/\/vicpress.net\/index.php?rest_route=\/wp\/v2\/posts\/6895\/revisions"}],"predecessor-version":[{"id":6900,"href":"https:\/\/vicpress.net\/index.php?rest_route=\/wp\/v2\/posts\/6895\/revisions\/6900"}],"wp:attachment":[{"href":"https:\/\/vicpress.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6895"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vicpress.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vicpress.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}