MS Access trying to set ADODB recordset to return from com object

Question

I have written a Shared Add In using VS 2008 which contains a public method that returns an ADO Recordset. In MS Access I would like to set a ADO Recordset to the return of the function call. The function call executes fine when calling the COM object. However assigning a ADO Recordset in VBA to the function returns a "Compile error: Invalid use of Property" . What am I doing wrong?

Dim result As ADODB.Recordset

result = .Object.doSomething(parameter1, parameter2)

HansUp · Accepted Answer · 2012-10-11 15:35:22Z

1

Use the Set keyword when assigning to an object variable.

Dim result As ADODB.Recordset

Set result = .Object.doSomething(parameter1, parameter2)

answered Oct 11, 2012 at 15:35

HansUp

97.3k11 gold badges80 silver badges139 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1738628 Over a year ago

Thanks Hansup, I rarely ever work in vba and have little experience in the syntax. Your suggestion worked!

Collectives™ on Stack Overflow

MS Access trying to set ADODB recordset to return from com object

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related