I wrote a function that returns an ADODB.Recordset. When the function is located in a a VB module that belongs to the GUI program, it works fine. When I place the function into a class module, I get runtime error #91 "Object variable or With block variable not set." I have tried all types of things to no avail. Any ideas?
Warner Smidt
Sun, 26 Sep 2004 01:36:49 GMT
Norman Yua #2 / 2
VB ADO recordset returned from MS SQL
Only your code can tell if you post it.
Quote:
> I wrote a function that returns an ADODB.Recordset. When the function is > located in a a VB module that belongs to the GUI program, it works fine. > When I place the function into a class module, I get runtime error #91 > "Object variable or With block variable not set." I have tried all types of > things to no avail. Any ideas?
VB ADO recordset returned from MS SQL