Hi,
I have a DB and make extensive use of public functions to perform various tasks. Using ADO I have a number of functions that open a recordset and return the associated recordset for subsequent processing....in some instances I can use msgbox rs.recordcount and it works as advertised, in other cases it generates an "Object doesn't support this method" issue.
I am opening all recordsets in the same way.....using adOpenDynamic and adlockOptimistic. SQL statement is sometimes generic as in "SELECT * From TableX" or with a specific criteria such as WHERE ABC=Criteria.
The function opening and returning the recordset completes and doesn't close the recordset (had issues with that before) before returning the rs for processing to the calling function.
I know the recordset has at least one record in it because I can msgbox one of the fields and it displays what i expect it to.
I am really puzzled by this......I just don't get what I am doing wrong or missing....
Many thanks for any suggestions
Lee
I have a DB and make extensive use of public functions to perform various tasks. Using ADO I have a number of functions that open a recordset and return the associated recordset for subsequent processing....in some instances I can use msgbox rs.recordcount and it works as advertised, in other cases it generates an "Object doesn't support this method" issue.
I am opening all recordsets in the same way.....using adOpenDynamic and adlockOptimistic. SQL statement is sometimes generic as in "SELECT * From TableX" or with a specific criteria such as WHERE ABC=Criteria.
The function opening and returning the recordset completes and doesn't close the recordset (had issues with that before) before returning the rs for processing to the calling function.
I know the recordset has at least one record in it because I can msgbox one of the fields and it displays what i expect it to.
I am really puzzled by this......I just don't get what I am doing wrong or missing....
Many thanks for any suggestions
Lee