{"id":298,"date":"2020-11-07T22:28:00","date_gmt":"2020-11-07T20:28:00","guid":{"rendered":"http:\/\/msaccess.pl\/?p=298"},"modified":"2020-11-08T22:30:11","modified_gmt":"2020-11-08T20:30:11","slug":"jak-usunac-dane-z-tabeli-na-podstawie-innej-tabeli-w-ms-access","status":"publish","type":"post","link":"https:\/\/msaccess.pl\/msaccess\/?p=298","title":{"rendered":"Jak usun\u0105\u0107 dane z tabeli na podstawie innej tabeli w MS Access"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Access ma kilka ogranicze\u0144, kt\u00f3re wymagaj\u0105 specjalnego podej\u015bcia. Jednym z nich jest usuwanie danych w oparciu o list\u0119 warto\u015bci z innej tabeli lub wyniku zapytania kwerendy. W filmie przedstawiam jak pokona\u0107 ograniczenia kwerendy usuwaj\u0105cej zawracaj\u0105cej b\u0142\u0105d przy pr\u00f3bie usuni\u0119cia danych na podstawie relacji.<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Jak usun\u0105\u0107 dane z tabeli na podstawie innej tabeli w MS Access\" width=\"1000\" height=\"563\" src=\"https:\/\/www.youtube.com\/embed\/E20Wh7ezu8g?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Access ma kilka ogranicze\u0144, kt\u00f3re wymagaj\u0105 specjalnego podej\u015bcia. Jednym z nich jest usuwanie danych w oparciu o list\u0119 warto\u015bci z innej tabeli lub wyniku zapytania kwerendy. W filmie przedstawiam jak pokona\u0107 ograniczenia kwerendy usuwaj\u0105cej zawracaj\u0105cej b\u0142\u0105d przy pr\u00f3bie usuni\u0119cia danych na podstawie relacji.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,14,10],"tags":[],"class_list":["post-298","post","type-post","status-publish","format-standard","hentry","category-analiza-danych","category-projektowanie-aplikacji","category-tutorial"],"_links":{"self":[{"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=\/wp\/v2\/posts\/298","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=298"}],"version-history":[{"count":1,"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=\/wp\/v2\/posts\/298\/revisions"}],"predecessor-version":[{"id":299,"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=\/wp\/v2\/posts\/298\/revisions\/299"}],"wp:attachment":[{"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/msaccess.pl\/msaccess\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}