Re: Access vs VB ado
From: Victor Koch ("Victor)
Date: 02/26/04
- Previous message: Len: "Access vs VB ado"
- In reply to: Len: "Access vs VB ado"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Feb 2004 17:18:12 -0300
Hi Len, try this in VB6
Rs.Open "SELECT ARSUBS02.*,
ProductNew2.*...................................
Rs.MoveLast
debug.print Rs.recordcount
And Replace " by ' in WHERE Condiction
WHERE (((ProductNew2.Pub)='GI'))
-- Víctor Koch From Argentina. "Len" <anonymous@discussions.microsoft.com> escribió en el mensaje news:488E9357-B5F2-4090-9D63-05C0D4701A83@microsoft.com... > Hi: > I'm not sure what forum this should be in. I have a query is Access2003 and cut and paste the query to VB6 (SP5) using ADO. I get a record count of 2,391 in Access but 2,238 in VB. Its easy to see missing records. Any help would be appreciated. Here's the query: > > SELECT ARSUBS02.*, ProductNew2.* > FROM ARSUBS02 INNER JOIN ProductNew2 ON ARSUBS02.ITEM = ProductNew2.Code > WHERE (((ProductNew2.Pub)="GI")) > ORDER BY ARSUBS02.CUSTNO, ARSUBS02.ITEM,ARSUBS02.NR_DATE;
- Previous message: Len: "Access vs VB ado"
- In reply to: Len: "Access vs VB ado"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
