scalar function return value into a VBA variable

  • Thread starter Thread starter =?ISO-8859-1?Q?Sztranyovszky_Tam=E1s?=
  • Start date Start date
?

=?ISO-8859-1?Q?Sztranyovszky_Tam=E1s?=

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
 
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
 
Back
Top