Article View: pl.comp.bazy-danych.msaccess
Article #137142Re: Access 2010 łączenie kilku kryteriów do kwerendy
From: MaciejF
Date: Sat, 30 Apr 2016 17:13
Date: Sat, 30 Apr 2016 17:13
18 lines
2086 bytes
2086 bytes
W dniu sobota, 30 kwietnia 2016 18:32:27 UTC+2 użytkownik leku napisał:
> Coś mi się zdaje że
> Docmd.RunSql służy do wywoływania kwerendy Akcji typu INSERT, UPDATE, DELATE
>
> i zwykłego SELECTA się nie wykona za pomocą tej metody :(
>
> pozdrawiam
Masz rację. Dawno nie pisałem w VBA.
Może tak:
Dim qdf As DAO.Querydef
Set qdf = CurrentDB.Querydefs("qGeneric")
qdf.SQL = sSQL
qdf.Execute
Pozdrawiam
MF
Technical Details
Message-ID:
<8aed9f36-9a23-43c1-b4a9-a6a820e54b3d@googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!feeder.erje.net!2.us.feeder.erje.net!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!sq19no756372igc.0!news-out.google.com!uv8ni293igb.0!nntp.google.com!i5no639759ige.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mailReferences:
<571b871d$0$641$65785112@news.neostrada.pl> <073ae140-8104-4f0b-8178-a838692eda19@googlegroups.com> <5724847c$0$22828$65785112@news.neostrada.pl> <fdc4a38d-07f8-41f4-bb94-723d97a4c145@googlegroups.com> <fd443da0-eedc-4a0c-a73f-0db905d90224@googlegroups.com> <5724ddf1$0$658$65785112@news.neostrada.pl>Show Full Headers
Complete Article Headers
X-Received: by 10.67.21.201 with SMTP id hm9mr17779307pad.26.1462036414977; Sat, 30 Apr 2016 10:13:34 -0700 (PDT) X-Received: by 10.50.92.1 with SMTP id ci1mr232001igb.1.1462036414937; Sat, 30 Apr 2016 10:13:34 -0700 (PDT) Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!feeder.erje.net!2.us.feeder.erje.net!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!sq19no756372igc.0!news-out.google.com!uv8ni293igb.0!nntp.google.com!i5no639759ige.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: pl.comp.bazy-danych.msaccess Date: Sat, 30 Apr 2016 10:13:34 -0700 (PDT) In-Reply-To: <5724ddf1$0$658$65785112@news.neostrada.pl> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=77.253.61.208; posting-account=kc7ZIQoAAAB5PkdJgxjq1dd8jnBK4MVp NNTP-Posting-Host: 77.253.61.208 References: <571b871d$0$641$65785112@news.neostrada.pl> <073ae140-8104-4f0b-8178-a838692eda19@googlegroups.com> <5724847c$0$22828$65785112@news.neostrada.pl> <fdc4a38d-07f8-41f4-bb94-723d97a4c145@googlegroups.com> <fd443da0-eedc-4a0c-a73f-0db905d90224@googlegroups.com> <5724ddf1$0$658$65785112@news.neostrada.pl> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <8aed9f36-9a23-43c1-b4a9-a6a820e54b3d@googlegroups.com> Subject: Re: Access 2010 łączenie kilku kryteriów do kwerendy From: MaciejF <maciejfr@onet.pl> Injection-Date: Sat, 30 Apr 2016 17:13:34 +0000 Lines: 18 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit