Variables dynamiques ???Résolu

Question

Slt !
Voici mon pb : Comment r&#233;cup&#233;rer les variables ???

Public Function Control(ByVal DataBaseName As String, _
                             Optional ByVal TableName As String = Empty, _
                             Optional ByVal Champs0 As String = Empty, _
                             Optional ByVal Champs1 As String = Empty, _
                             Optional ByVal Champs2 As String = Empty, _
                             Optional ByVal Champs3 As String = Empty, _
                             Optional ByVal Champs4 As String = Empty, _
                             Optional ByVal Champs5 As String = Empty, _
                             Optional ByVal Champs6 As String = Empty, _
                             Optional ByVal Champs7 As String = Empty, _
                             Optional ByVal Champs8 As String = Empty, _
                             Optional ByVal Champs9 As String = Empty) As Integer
..............


          If "Champs" & ii <> "" Then
             .Fields.Append .CreateField("Champs" & ii, dbText)
          End If
...........
end function

Merci

NHenry · Accepted Answer

ParamArray


Il est plus facile de batiser kk1 que de la convertir. (surtout en programmation)



NH

Variables dynamiques ???

1 réponse

Discussions similaires