rs.find error

• • Reply

  19 years ago

  by Adamg

  Adamg

  , United States

  Joined 19 years ago

  I get the error rowset does not support scrolling backwards...
  

  
  here is my code...
  

  
  rs.MoveFirst
  rs.Find "username = 'Adam'"

  Report abuse
• • Reply

  19 years ago

  by hobbes68

  hobbes68

  Milan, United States

  Joined 19 years ago

  Are you not at the beginning of the recordset BEFORE you have a rs.movefirst and maybe you have a static recordset?
  

  
  how about filtering the recordset (it works only if you are searching for the record though, not if you are looking for a position in the recordset...)
  

  
  rs.filter = "username = 'Adam'"
  

  
  and you get it...

  Report abuse
• • Reply

  19 years ago

  by CodeWarrior76

  CodeWarrior

  Calgary, CA, United States

  Joined 19 years ago

  Make sure that you're not opening it as a forward-only recordset.  open it with the adOpenStatic or adOpenDynamic cursor types
  

  
  like this:
  

  
  Call rs.Open("SELECT * FROM TableName" , cn, adOpenStatic, adLockOptimistic)
  

  
  The last parameter can be omitted as the default value would be fine.

  Report abuse