coding of open recordsets

  • Thread starter Thread starter getwin
  • Start date Start date
G

getwin

Hi all,

I want to open recordsets in Table_A with the value of Col_1
<>Full;<>Empty and <>Half by VBA.

Now I do the action by running two queries and it is very time
consuming (about 5 minutes).

Access 2K; Table_A--500,000 records;

Please help.
Thanks
dymon
 
RobFMS said:
Are "Full", "Empty" and "Half" values of Column 1? Otherwise, are you asking
about the quantity of records?

--

Rob

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Problems with your database? Need to upgrade your application?
Contact the FMS Professional Solutions Group: www.fmsinc.com/consulting

Need a Book Recommendation?
www.fmsinc.com/toplevel/books.htm

Need software tools for Access, VB or .NET?
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Click to expand...

Hi Rob,

Yes, they're values of Col_1.
Exactly, Col_1 contains values: Full, Half, Quarter and Empty.
I want to see records in Table_A where Col_1 <>Quarter.
May be something like this (as far as I know):

Dim rs as ADODB.Recordset
rs.open ("select * from Table_A where Col_1<>Quarter")
..
..
..
set rs=nothing

Please help with the completed script.
I'm a newbies of using/writing VBA.

dymon
 
Back
Top