UDF as field data source

  • Thread starter Thread starter furkat
  • Start date Start date
F

furkat

Hi All,

I have one UDF (user-defined function in MS SQL 200) which returns me one
value, and I want to use it as a data source for a filed in my form (.adp MS
Access 2000). And I can't find the right syntax to reference my UDF. Could
you kindly point me to the right syntax?

Kind regards

Furkat
 
Hi All,

I have one UDF (user-defined function in MS SQL 200) which returns me
one value, and I want to use it as a data source for a filed in my form
(.adp MS Access 2000). And I can't find the right syntax to reference my
UDF. Could you kindly point me to the right syntax?

Kind regards

Furkat
Click to expand...

Owner.UDF(Param, Param, ...)
 
Hello, furkat!
You wrote in message on Fri, 7 May 2004 13:22:46 +0500:

f> I have one UDF (user-defined function in MS SQL 200) which returns me
f> one value, and I want to use it as a data source for a filed in my form
f> (.adp MS Access 2000). And I can't find the right syntax to reference my
f> UDF. Could you kindly point me to the right syntax?

If your form is bound on a query, you can include UDF's call into it
and use as a "Control Source" for a necessary field. Otherwise you can do it
via VBA. For an example:

Private Sub Form_Open(Cancel As Integer)
Me.Text0 = CurrentProject.Connection.Execute("select owner.udf_name()")(0)
End Sub

With best regards, Igor.
ICQ: 111469481
 
Back
Top