scalar function return value into a VBA variable

[Sztranyovszky Tamás]

Hello,

I want to assign the return value of my MSDE scalar function to a
variable in VBA. The functions returns a DECIMAL(12,6) value. Please,
help me, how to do this... (I am using Access 2003, MDAC 2.8)

Thanks

 

[Graham R Seach]

I'm pretty certain you need to embed the call to the UDF within a stored
procedure, and use an ADO Command parameter to retrieve it.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia