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

  • 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).