Home Forums Microsoft Access Microsoft Access call a SQL Server User Defined Function from Access query RE: call a SQL Server User Defined Function from Access query
rf44
SSCommitted
Points: 1515
More actions
June 14, 2013 at 11:42 am
#1624227
In the VBA procedure, I would try:
strSQL = "SELECT dbo.udf_GetStuff (44, 22)"
Then:
varReturn = .OpenRecordset.GetRows
And finally retrieve the value returned by the udf from varReturn(0, 0).