I'm using ADO 2.5 ( with the 2.5 recordset library, if that means anything ).
1. Changed name of 'source' object to 'CNN'.
2. CNN.CursorLocation = adUseClient causes a 'no such interface supported' error when the code hits: Set Me.List2.Recordset = RST
3. Tried RST.MoveFirst
No luck...
Thanks for the tip.
I commented out the lines you suggested and put in the code you offered for testing the validity of the recordset.
The recordset has 3 records, but they still don't show up in the list box.
I'm not sure why this doesn't work.
Hello all,
I'm using Access 2002 and SQL server 7.
Code attached.
I am trying to populate a list box from a recordset using the box's recordset property. I have two versions of a connection string within the code; one for connecting to a Jet database, and the other for connecting to a SQL...
Hello all,
I'm using Access 2002 and SQL server 7.
Code attached.
I am trying to populate a list box from a recordset using the box's recordset property. I have two versions of a connection string within the code; one for connecting to a Jet database, and the other for connecting to a SQL...
Hello all,
I'm using Access 2002 and SQL server 7.
Code attached.
I am trying to populate a list box from a recordset using the box's recordset property. I have two versions of a connection string within the code; one for connecting to a Jet database, and the other for connecting to a SQL...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.