G Galla Aug 19, 2009 #1 I need to run a SQL Server function from VBA (adp). Is there any way to do this? Thanks for your help.
I need to run a SQL Server function from VBA (adp). Is there any way to do this? Thanks for your help.
D David H Aug 19, 2009 #2 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
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
G Galla Aug 19, 2009 #3 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.
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.
G Galla Aug 19, 2009 #4 I have found my answer: http://bytes.com/topic/access/answers/748448-calling-scalar-value-sql-server-function-adp
I have found my answer: http://bytes.com/topic/access/answers/748448-calling-scalar-value-sql-server-function-adp
