Option Explicit

      Public Function Join(source() As String, Optional _
            sDelim As String = " ") As String
      Dim sOut As String, iC As Integer
      On Error GoTo errh:
          For iC = LBound(source) To UBound(source) - 1
              sOut = sOut & source(iC) & sDelim
          Next
          sOut = sOut & source(iC)
          Join = sOut
          Exit Function
      errh:
          Err.Raise Err.Number
      End Function
      
      ' Para trabajar en Access 97
      Public Function Split(ByVal sIn As String, Optional sDelim As _
            String, Optional nLimit As Long = -1, Optional bCompare As _
             Long = vbBinaryCompare) As Variant

      ' Para trabajar con Access 2000 o superior
      'Public Function Split(ByVal sIn As String, Optional sDelim As _
            String, Optional nLimit As Long = -1, Optional bCompare As _
             VbCompareMethod = vbBinaryCompare) As Variant

          Dim sRead As String, sOut() As String, nC As Integer
          If sDelim = "" Then
              Split = sIn
          End If
          sRead = ReadUntil(sIn, sDelim, bCompare)
          Do
              ReDim Preserve sOut(nC)
              sOut(nC) = sRead
              nC = nC + 1
              If nLimit <> -1 And nC >= nLimit Then Exit Do
              sRead = ReadUntil(sIn, sDelim)
          Loop While sRead <> ""
          ReDim Preserve sOut(nC)
          sOut(nC) = sIn
          Split = sOut
      End Function
    
      ' Para trabajar con Access 97
      Public Function ReadUntil(ByRef sIn As String, _
            sDelim As String, Optional bCompare As Long _
          = vbBinaryCompare) As String

      ' Para trabajar con Access 2000 o superior
      'Public Function ReadUntil(ByRef sIn As String, _
            sDelim As String, Optional bCompare As VbCompareMethod _
          = vbBinaryCompare) As String

          Dim nPos As String
          nPos = InStr(1, sIn, sDelim, bCompare)
          If nPos > 0 Then
              ReadUntil = Left(sIn, nPos - 1)
              sIn = Mid(sIn, nPos + Len(sDelim))
          End If
      End Function

      Public Function StrReverse(ByVal sIn As String) As String
          Dim nC As Integer, sOut As String
          For nC = Len(sIn) To 1 Step -1
          sOut = sOut & Mid(sIn, nC, 1)
          Next
          StrReverse = sOut
      End Function

      ' Para trabajar con Access 97
      Public Function InStrRev(ByVal sIn As String, sFind As String, _
       Optional nStart As Long = 1, Optional bCompare As _
            Long = vbBinaryCompare) As Long

      ' Para trabajar con Access 2000 o superior
      'Public Function InStrRev(ByVal sIn As String, sFind As String, _
       Optional nStart As Long = 1, Optional bCompare As _
            VbCompareMethod = vbBinaryCompare) As Long
          Dim nPos As Long
          sIn = StrReverse(sIn)
          sFind = StrReverse(sFind)
          nPos = InStr(nStart, sIn, sFind, bCompare)
          If nPos = 0 Then
              InStrRev = 0
          Else
              InStrRev = Len(sIn) - nPos - Len(sFind) + 2
          End If
      End Function

      ' Para trabajar con Access 97
      Public Function Replace(sIn As String, sFind As String, _
            sReplace As String, Optional nStart As Long = 1, _
            Optional nCount As Long = -1, Optional bCompare As _
            Long = vbBinaryCompare) As String

      ' Para trabajar con Access 2000 o superior
      'Public Function Replace(sIn As String, sFind As String, _
            sReplace As String, Optional nStart As Long = 1, _
            Optional nCount As Long = -1, Optional bCompare As _
            VbCompareMethod = vbBinaryCompare) As String

          Dim nC As Long, nPos As Integer, sOut As String
          sOut = sIn
          nPos = InStr(nStart, sOut, sFind, bCompare)
          If nPos = 0 Then GoTo EndFn:
          Do
              nC = nC + 1
              sOut = Left(sOut, nPos - 1) & sReplace & _
                 Mid(sOut, nPos + Len(sFind))
              If nCount <> -1 And nC >= nCount Then Exit Do
              nPos = InStr(nStart, sOut, sFind, bCompare)
          Loop While nPos > 0
      EndFn:
          Replace = sOut
      End Function

						
      'Para probar el código, por ejemplo de Join y Split 
      Option Explicit

      Dim MyArray(2) As String, MyStr As String, MyVar As Variant

      Private Sub Command1_Click()
          MyArray(0) = "item1"
          MyArray(1) = "item2"
          MyArray(2) = "item3"
          MyStr = Join(MyArray, ";")
          Debug.Print MyStr
      End Sub

      Private Sub Command2_Click()
          Dim i As Integer
          MyVar = Split(MyStr, ";")
          For i = LBound(MyVar) To UBound(MyVar)
          Debug.Print MyVar(i)
          Next
      End Sub

===================================================================
Estas funciones han sido corregidas por Juan M. Afán de Ribera =
===================================================================
     

Comentar que tambien, estas funciones escritas aqui las podemos utilizar en las versiones
Access 2000 y XP (activar la línea de declaración indicada para la versión que trabajes),
por que, aunque ya existen y vienen integradas las originales, podemos personalizar aun 
más estas funciones anexas a este escrito. En la mayoría de las ocasiones no tendrá sentido
hacerlo pero quizá en algún caso concreto sí.

En este sentido, para Access 2000 o XP, podremos utilizar la funcion nuestra o la
correspondiente funcion propia de VBA, sin mas que llamar asi: (Por ejemplo, con Replace)

Replace ->Se ejecuta nuestra funcion
Vba.Replace ->Se ejecuta la funcion propia de Access.


Saludos desde Valladolid (y Barcelona, jeje)
Búho y happy

    Source: geocities.com/es/ensolva/Descargas/Documentos

               ( geocities.com/es/ensolva/Descargas)                   ( geocities.com/es/ensolva)                   ( geocities.com/es)