I am using a Listview control in my Access 97 database. I have a routine (called by the column click event) that will sort a column of non-string values. Here is the header of the routine that is giving me the error:
The error I get when I try to save my work is:
"Compile error: Automation type not supported in Visual Basic"
The error is on MSComctlLib.ListSortOrderConstants.
I do have Access 2000 installed on my machine, and after sonme reading, I did re-register the DAO350.dll.
However, I still get the error.
Anyone know how I can use MSComctlLib.ListSortOrderConstants in my Access 97 db?
Thanks,
JBG
Code:
Public Sub ListViewSortOnNonStringField(LV As ListView, ByVal ColumnIndex As Integer, _
Optional SortOrder As MSComctlLib.ListSortOrderConstants, Optional IsDateValue As Boolean)The error I get when I try to save my work is:
"Compile error: Automation type not supported in Visual Basic"
The error is on MSComctlLib.ListSortOrderConstants.
I do have Access 2000 installed on my machine, and after sonme reading, I did re-register the DAO350.dll.
However, I still get the error.
Anyone know how I can use MSComctlLib.ListSortOrderConstants in my Access 97 db?
Thanks,
JBG
