Does anyone know why this line seems to not work in Access 2000 (this database was converted from Access97):
Declare Function adh_accSortStringArray Lib "msaccess.exe" Alias "#81" _
(astrObjects() As String) As Long
Formerly, I used this function to alphabetize my combo and list boxes but now the order is all messed up and if I open a form with the offending controls Access 2000 will not close without using Task Manager.
I am using these libraries:
Visual Basic for Applications
MS Access 9.0 Object Library
MS DAO 3.6 Object Library
MS Forms 2.0 Object Library
MS VBA Extensibility 5.3
I have tried switching MS DAO 3.6 Object Library with MS DAO 2.5/3.5 Compatability Library. And I have tried without using MS Forms 2.0 Object Library (since it doesn't seem to come with Access 2000).
Or, if someone could tell me how to examine Libraries to see what Alias I need to use or even which libraries I should use, please feel free.