How to access SQL Server scalar functions in MS Access VB -

I'm trying to figure out how I could use a scalar function of the SQL Server database to your APP file I am

I have an ADP file and a SQL Server 2005 DB in 2007.

In VB access, I try to get the results of a scalar function with parameters.

I tried with the DAO, but that case currentdb = nothing:

  DAO as the slow DBS Dibes DM SQL 2 string set integer as a string Diaimtiaisiant as Dimtititi L = current DB txt = "SELECT * The FROM Dbo.TBL_Klanten" '(tbl_klanten msql DB)' dbs.Execute txt, dbFailOnError  < 
 
 DAO was never designed to reach SQL Server, although it is possible 
 
 I believe the current DD property is the DAO connection which is to access the Access database Rbhit is, and can not work with ADP, even though I do not really know because I never use them. 
> ADO is the way you want to go with it. 
 
 I also believe that you are sticking with VBA instead of doing anything with .NET.