Article View: pl.comp.bazy-danych.msaccess
Article #137540Re: wywołanie kwerendy bez zapisywania qd
From: LeszekN
Date: Tue, 17 Oct 2017 06:48
Date: Tue, 17 Oct 2017 06:48
15 lines
2048 bytes
2048 bytes
Dim db as database Dim sSql as string Dim rs as recordset sSQL = "SELECT c.INDEKS, d.WAGA*c.[DILOSC] AS WAGA " & _ "FROM tbl_" & sRM AS c INNER JOIN mg00imni AS d ON c.INDEKS = d.INDEKS ;" 'Nie wnikam w poprawność stringu Set db = DBEngine(0)(0) Set rs = CurrentDb.OpenRecordset(sSQL) w tym momencie możesz zrobić z danymi co chcesz, dane są w recordsecie czyli rs Jeżeli dane chcesz wyświetlić tylko na ekran to prościej zrobić raport lub formularz, bez kombinowania w kodzie, lub wykorzystać recordset jako źródło danych dla raportu lub formularza.
Technical Details
Message-ID:
<ad000c36-b0d8-4fc7-a57e-85583d03fe3d@googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!peer01.am4!peer.am4.highwinds-media.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!z50no22874qtj.0!news-out.google.com!r5ni77qtc.1!nntp.google.com!z50no22873qtj.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mailReferences:
<c723428f-461e-4334-b0e0-9e92f7f8eb5c@googlegroups.com> <312fa906-5694-4d88-8379-ddf565030c9b@googlegroups.com>Show Full Headers
Complete Article Headers
X-Received: by 10.55.155.21 with SMTP id d21mr10373796qke.50.1508222938803; Mon, 16 Oct 2017 23:48:58 -0700 (PDT) X-Received: by 10.31.153.21 with SMTP id b21mr920304vke.13.1508222938752; Mon, 16 Oct 2017 23:48:58 -0700 (PDT) Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!peer01.am4!peer.am4.highwinds-media.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!z50no22874qtj.0!news-out.google.com!r5ni77qtc.1!nntp.google.com!z50no22873qtj.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: pl.comp.bazy-danych.msaccess Date: Mon, 16 Oct 2017 23:48:58 -0700 (PDT) In-Reply-To: <312fa906-5694-4d88-8379-ddf565030c9b@googlegroups.com> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=193.192.179.172; posting-account=i0RtOwoAAABRI8EWUf_BQOpbS6yj4J_N NNTP-Posting-Host: 193.192.179.172 References: <c723428f-461e-4334-b0e0-9e92f7f8eb5c@googlegroups.com> <312fa906-5694-4d88-8379-ddf565030c9b@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <ad000c36-b0d8-4fc7-a57e-85583d03fe3d@googlegroups.com> Subject: Re: wywołanie kwerendy bez zapisywania qd From: LeszekN <leszeknowak@wp.pl> Injection-Date: Tue, 17 Oct 2017 06:48:58 +0000 X-Received-Body-CRC: 4008692318 X-Received-Bytes: 2028 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit