{"id":667,"date":"2020-08-21T08:44:35","date_gmt":"2020-08-21T08:44:35","guid":{"rendered":"http:\/\/mio-web.net\/pcsupport\/?p=667"},"modified":"2020-08-21T08:44:35","modified_gmt":"2020-08-21T08:44:35","slug":"access-vba%e3%80%80form%e3%81%ae%e3%82%b3%e3%83%b3%e3%83%88%e3%83%ad%e3%83%bc%e3%83%ab%e5%90%8d%e3%81%ab%e9%80%a3%e7%95%aa%e3%81%ae%e5%a4%89%e6%95%b0%e3%82%92%e5%90%ab%e3%82%81%e3%81%a6%e4%bd%bf","status":"publish","type":"post","link":"https:\/\/mio-web.net\/pcsupport\/archives\/667\/","title":{"rendered":"ACCESS VBA\u3000Form\u306e\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u540d\u306b\u9023\u756a\u306e\u5909\u6570\u3092\u542b\u3081\u3066\u4f7f\u3044\u305f\u3044"},"content":{"rendered":"\n<p>ACCESS VBA \u3067\u3000\u30d5\u30a9\u30fc\u30e0\u306e\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\uff08\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\uff09\u306e\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u540d\u306b\u3000\u5909\u6570\u306e\u9023\u756a\u3092\u7528\u3044\u3066\u3001\u53c2\u7167\u3057\u305f\u3044\u5834\u5408<\/p>\n\n\n\n<p>\u305f\u3068\u3048\u3070\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u3068\u3057\u3066\u3000cnt0 \u304b\u3089 cnt11  \u3001 zei0 \u304b\u3089 zei11 \u306a\u3069\u304c\u3042\u308b\u5834\u5408\u3001\u4e0b\u8a18\u306e\u3088\u3046\u306b\u53c2\u7167\u3067\u304d\u308b<\/p>\n\n\n\n<p>&#8216;\u5408\u8a08\u6b04<\/p>\n\n\n\n<p>For i = 0 To 11 \u3000\u3000\u3000&#8217;\u958b\u59cb\u6708\u304b\u3089\u306e12\u6708<\/p>\n\n\n\n<p>.Cells(10, i + 2).Value = Me.F_\u6708\u5225\u96c6\u8a08<em>\u652f\u6255<\/em>\u30b5\u30d6.Form.Controls(&#8220;cnt&#8221; &amp; i)<\/p>\n\n\n\n<p>.Cells(14, i + 2).Value = Me.F_\u6708\u5225\u96c6\u8a08<em>\u7a0e\u5225<\/em>\u30b5\u30d6.Form.Controls(&#8220;cnt&#8221; &amp; i)<br>.Cells(15, i + 2).Value = Me.F_\u6708\u5225\u96c6\u8a08<em>\u7a0e\u5225<\/em>\u30b5\u30d6.Form.Controls(&#8220;zei&#8221; &amp; i)<br>.Cells(16, i + 2).Value = Me.F_\u6708\u5225\u96c6\u8a08<em>\u7a0e\u5225<\/em>\u30b5\u30d6.Form.Controls(&#8220;zk&#8221; &amp; i)<\/p>\n\n\n\n<p>.Cells(39, i + 2).Value = Me.F_\u6708\u5225\u96c6\u8a08<em>\u76f8\u6bba<\/em>\u30b5\u30d6.Form.Controls(&#8220;cnt&#8221; &amp; i)<\/p>\n\n\n\n<p>.Cells(41, i + 2).Value = Me.Controls(&#8220;fk&#8221; &amp; i)<\/p>\n\n\n\n<p>Next i<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>ACCESS VBA \u3067\u3000\u30d5\u30a9\u30fc\u30e0\u306e\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\uff08\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\uff09\u306e\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u540d\u306b\u3000\u5909\u6570\u306e\u9023\u756a\u3092\u7528\u3044\u3066\u3001\u53c2\u7167\u3057\u305f\u3044\u5834\u5408 \u305f\u3068\u3048\u3070\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u3068\u3057\u3066\u3000cnt0 \u304b\u3089 cnt11 \u3001 zei0 \u304b\u3089 zei11 \u306a\u3069 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"vkexunit_cta_each_option":"","footnotes":""},"categories":[24],"tags":[],"class_list":["post-667","post","type-post","status-publish","format-standard","hentry","category-access"],"_links":{"self":[{"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/posts\/667","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/comments?post=667"}],"version-history":[{"count":1,"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/posts\/667\/revisions"}],"predecessor-version":[{"id":668,"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/posts\/667\/revisions\/668"}],"wp:attachment":[{"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/media?parent=667"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/categories?post=667"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mio-web.net\/pcsupport\/wp-json\/wp\/v2\/tags?post=667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}