Thread: Recordset keeps returning EOF and shouldn't be.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
colofnature[_6_] colofnature[_6_] is offline
external usenet poster
  
Posts: 1
Default Recordset keeps returning EOF and shouldn't be.

After your "rst.Open..." command, try putting in the following:


if rst.RecordCount = 0 Then
GoTo NextPolicy
Else
rst.MoveLast
rst.MoveLast
End If


The MoveLast causes the DB handler to populate the recordset, and th
MoveFirst sets the first record as the current one

--
colofnatur
-----------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...fo&userid=3435
View this thread: http://www.excelforum.com/showthread.php?threadid=54470

Reply With QuoteReply With Quote