Re: UDF as field data source
From: furkat (furkatfzNOSPAM_at_hotmail.com)
Date: 05/08/04
- Next message: BJ Freeman: "Re: Senior Developer looking for your asst in employmt issue (not job seeking!)"
- Previous message: Timo: "Re: Senior Developer looking for your asst in employmt issue (not job seeking!)"
- In reply to: Igor V. Makeev: "Re: UDF as field data source"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 8 May 2004 22:02:29 +0500
Thank you
this solved my problem. Спасибо, Игорь!
Kind regards
Furkat
"Igor V. Makeev" <igor@mebelmassiv.tula.ru> сообщил/сообщила в новостях
следующее: news:eqpYLTDNEHA.3052@TK2MSFTNGP12.phx.gbl...
> 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
>
>
- Next message: BJ Freeman: "Re: Senior Developer looking for your asst in employmt issue (not job seeking!)"
- Previous message: Timo: "Re: Senior Developer looking for your asst in employmt issue (not job seeking!)"
- In reply to: Igor V. Makeev: "Re: UDF as field data source"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
