Article View: be.comp.programming
Article #9780Re: foutje in vb 6.0.
From: SpaceRunner
Date: Mon, 08 Apr 2002 16:32
Date: Mon, 08 Apr 2002 16:32
22 lines
1548 bytes
1548 bytes
ikke wrote:
> blijkbaar is deze syntax fout, geeft iemand een idee waarom???
>
>
> Set registerrs = copyloggerdb.OpenRecordset(" select * from registraties
> WHERE Date between #" & Format(Calendar1.Value, "MM/DD/YYYY") & "# and #"
> & Format(Calendar2.Value, "MM/DD/YYYY") & "# And Kostenplaats like
> kostplaats And Persoon like gebruiker", dbOpenDynaset)
>
> cdr@pandora.be
Vraagje: zijn "kostplaats" en "gebruiker" variabelen of effectieve tekst.
Indien dat laaste: beiden tussen enkel quotes zetten (').
En wat die syntaxfout betreft: je zult wel wat meer info moeten geven
anders kan ik je niet echt helpen.
Mvg,
Andy.
--
Remove 'x.' to send mail.
Technical Details
Message-ID:
<3cb1c7c8$0$8137$ba620e4c@news.skynet.be>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!isdnet!skynet.be!skynet.be!louie!not-for-mailReferences:
<dKds8.2303$LY2.333326473@hebe.telenet-ops.be>Show Full Headers
Complete Article Headers
X-Google-Language: DUTCH,ASCII-7-bit X-Google-Thread: fcea4,b8f8a0bbad5504f9 X-Google-Attributes: gidfcea4,public X-Google-ArrivalTime: 2002-04-08 09:39:38 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!isdnet!skynet.be!skynet.be!louie!not-for-mail Message-ID: <3cb1c7c8$0$8137$ba620e4c@news.skynet.be> From: SpaceRunner <x.spacerunner@skynet.be> Subject: Re: foutje in vb 6.0. Newsgroups: be.comp.programming Date: Mon, 08 Apr 2002 18:32:28 +0200 References: <dKds8.2303$LY2.333326473@hebe.telenet-ops.be> User-Agent: KNode/0.6.1 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit Lines: 22 Organization: -= Skynet Usenet Service =- NNTP-Posting-Host: 217.136.139.68 X-Trace: 1018283977 reader0.news.skynet.be 8137 217.136.139.68 X-Complaints-To: abuse@skynet.be