Calling a MS SQL Server scalar UDF from vba

Question

I am programming an Access 2007 (accdb, not adp) frontend at connect to a SQL Server 2005 backend. How can I call a scalar user defined function from my vba code?

Answer 1

Create a query that calls the function.

SELECT [FirstName], [Surname]
  FROM dbo.FindCustomersOrderByDesc();

Answer 2

Dim rst As ADODB.Recordset
Set rst = Connection.Execute("SELECT dbo.MyFunction('" & Me.field & "')")