Hello LJ,
---------------Code---------------------------------
Dim fieldsArrayList
Dim fieldsIdsArray
fieldsArrayList = Access.server.GetListField("HPD:Help Desk")
fieldsIdsArray = fieldsArrayList.ToArray()
fieldsArrayList = Nothing
Dim i, ARfieldObject, fieldsNamesArray()
ReDim fieldsNamesArray(UBound(fieldsIdsArray))
For i = LBound(fieldsIdsArray) To UBound(fieldsIdsArray)
fieldsIdsArray(i) = CLng(fieldsIdsArray(i))
ARfieldObject = Access.server.GetField("HPD:Help Desk",
fieldsIdsArray(i))
fieldsNamesArray(i) = ARfieldObject.Name
ListBox1.Items.Add(fieldsNamesArray(i))
Next
---------------------------------------------------------------------------
Where in my code I should check the field type? Do you see any issue in my
code? It is taking very long time to fetch the field names
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
