M
MyndPhlyp
One of the things I'd like to do is retrieve the name of the underlying
table (or query) for an ADODB.Recordset even if the Recordset is closed.
That tends to rule out sifting through the Properties since a closed
Recordset has no Properties.
Walking on new ground, it almost looks like I could write up a Property
Get/Let/Set for the Recordset, but I can't seem to get just what I want.
What I'd /*like*/ to achieve is something as slick as:
strTableName = rsMyTable.Name
Can one of you gurus help me out with a quick VBA sample of how to do this
or something similar?
table (or query) for an ADODB.Recordset even if the Recordset is closed.
That tends to rule out sifting through the Properties since a closed
Recordset has no Properties.
Walking on new ground, it almost looks like I could write up a Property
Get/Let/Set for the Recordset, but I can't seem to get just what I want.
What I'd /*like*/ to achieve is something as slick as:
strTableName = rsMyTable.Name
Can one of you gurus help me out with a quick VBA sample of how to do this
or something similar?