Article View: pl.comp.bazy-danych.msaccess
Article #137157Re: Access 2010 łączenie kilku kryteriów do kwerendy
From: leku
Date: Sat, 30 Apr 2016 21:59
Date: Sat, 30 Apr 2016 21:59
30 lines
2416 bytes
2416 bytes
Podziwiam twoją cierpliwość
Nie wiem na czym testujesz procedurę ale mój Access
jej nie wykonuje.
Debuger zatrzymuje sie na linijce
DoCmd.DeleteObject(acQuery, "qTemp")
podświetla na czerwono tekst
i dalej
Set qdf = CurrentDb.QueryDefs("qTemp")
na żółto tło
+ komunikat
Compile error: Syntax error
Wygląda, że Access nie widzi kwerendy, której faktycznie nie ma qTemp
Natomiast
Debug.Print sCond
zwraca
"""A1"",""B1"",""C1"""
pozdrawiam
Technical Details
Message-ID:
<57252aa5$0$22837$65785112@news.neostrada.pl>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!goblin3!goblin1!goblin.stu.neva.ru!newsfeed.neostrada.pl!unt-exc-01.news.neostrada.pl!unt-spo-b-01.news.neostrada.pl!news.neostrada.pl.POSTED!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> <8aed9f36-9a23-43c1-b4a9-a6a820e54b3d@googlegroups.com> <eafa8aa8-8082-4adf-ab98-8f001100dcc3@googlegroups.com> <5724f365$0$22836$65785112@news.neostrada.pl> <4e19ace0-0be4-4e68-9b5a-3d7d0c34e3c4@googlegroups.com> <57250406$0$702$65785112@news.neostrada.pl> <6c243994-66c8-4e7b-af0d-72b3f05ff0ac@googlegroups.com> <4fed699d-ee1c-43f1-930a-0ffa53b2ff25@googlegroups.com> <7dc787d8-572e-4067-b5a6-dda8b3dfa563@googlegroups.com> <5a972ec7-e959-4108-8d3e-1bb0a1106bbc@googlegroups.com> <e2a70f5f-9995-4c0e-8370-4dbb60cda417@googlegroups.com>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!goblin3!goblin1!goblin.stu.neva.ru!newsfeed.neostrada.pl!unt-exc-01.news.neostrada.pl!unt-spo-b-01.news.neostrada.pl!news.neostrada.pl.POSTED!not-for-mail From: "leku" <lekucz@wp.pl> Newsgroups: pl.comp.bazy-danych.msaccess 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> <8aed9f36-9a23-43c1-b4a9-a6a820e54b3d@googlegroups.com> <eafa8aa8-8082-4adf-ab98-8f001100dcc3@googlegroups.com> <5724f365$0$22836$65785112@news.neostrada.pl> <4e19ace0-0be4-4e68-9b5a-3d7d0c34e3c4@googlegroups.com> <57250406$0$702$65785112@news.neostrada.pl> <6c243994-66c8-4e7b-af0d-72b3f05ff0ac@googlegroups.com> <4fed699d-ee1c-43f1-930a-0ffa53b2ff25@googlegroups.com> <7dc787d8-572e-4067-b5a6-dda8b3dfa563@googlegroups.com> <5a972ec7-e959-4108-8d3e-1bb0a1106bbc@googlegroups.com> <e2a70f5f-9995-4c0e-8370-4dbb60cda417@googlegroups.com> In-Reply-To: <e2a70f5f-9995-4c0e-8370-4dbb60cda417@googlegroups.com> Subject: Re: Access 2010 łączenie kilku kryteriów do kwerendy Date: Sat, 30 Apr 2016 23:59:14 +0200 MIME-Version: 1.0 X-Priority: 3 X-MSMail-Priority: Normal Importance: Normal X-Newsreader: Microsoft Windows Live Mail 16.4.3528.331 X-MimeOLE: Produced By Microsoft MimeOLE V16.4.3528.331 Lines: 31 Message-ID: <57252aa5$0$22837$65785112@news.neostrada.pl> Organization: Telekomunikacja Polska NNTP-Posting-Host: 79.186.216.205 X-Trace: 1462053541 unt-rea-a-02.news.neostrada.pl 22837 79.186.216.205:63845 X-Complaints-To: abuse@news.neostrada.pl Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit