Andre’s Weblog

MultiFind, Función Find con varios parámetros

Posteado por: Andrea en: mayo 5, 2011

Public Sub Multi_Find(ByRef oRs As ADODB.Recordset, sCriteria As String)
 Dim clone_rs As ADODB.Recordset
 Set clone_rs = oRs.Clone

      clone_rs.Filter = sCriteria
      If clone_rs.EOF Or clone_rs.BOF Then
       oRs.MoveLast
       oRs.MoveNext
      Else
       oRs.Bookmark = clone_rs.Bookmark
      End If

      clone_rs.Close
      Set clone_rs = Nothing

 End Sub
Advertisement

Deja un comentario

Fill in your details below or click an icon to log in:

Logo de WordPress.com

You are commenting using your WordPress.com account. Log Out / Cambiar )

Twitter picture

You are commenting using your Twitter account. Log Out / Cambiar )

Facebook photo

You are commenting using your Facebook account. Log Out / Cambiar )

Connecting to %s

Seguir

Get every new post delivered to your Inbox.