View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Damian Carrillo[_3_] Damian Carrillo[_3_] is offline
external usenet poster
 
Posts: 19
Default Stubborn Array won't Populate from single ADODB.Connection Query

Sorry Joel, this didn't work either. Its not a valid property.

On Aug 25, 1:31*am, Joel wrote:
You need to use a movenext. *I still think you should fix your DQL like I
recommended last time so you don't have to loop 5 times. *It significantly
slows down the code.

* *Let SQLquery = QueryUserInfo(x) 'Define source query
* *Set RecSet = Conn.Execute(SQLquery, , 1) 'Retrieve query value
* *Do until RecSet.Eof

* * * *For x = 0 To 5
* * * * * *Let SQLquery = QueryUserInfo(x) 'Define source query
* * * * * *Set RecSet = Conn.Execute(SQLquery, , 1) 'Retrieve query value
* * * * * *Let UserInfo(x) = RecSet.Fields.Item(0).Value 'Populate value
into field
* * * *Next x

* * * *RecSet.MobeNext
* *Loop