Possible to run SQL Server 2005 function from VBA?

[Galla]

I need to run a SQL Server function from VBA (adp). Is there any way to
do this?

Thanks for your help.

 

[David H]

Do you mean a stored procedure or a function? If its a stored procedure the
article below will get you started.

http://msdn.microsoft.com/en-us/library/aa198007(SQL.80).aspx

 

[Galla]

Thanks, David. I'm already aware that it is possible to execute a stored
procedure from VBA. But is there a way to run a function?

Thanks.

 

[Galla]

I have found my answer:
http://bytes.com/topic/access/answers/748448-calling-scalar-value-sql-server-function-adp