Hente værdi fra formular (MSAccess XP Frontend)

hi martens
If I understand you correctly you have a database in MS SQL Server and you want to make an SQL statement which references a field on a form in an Access application. If your making the SQL dirctly in SQL Server (Enterprise managere or Query Analyser) then it is NOT possible. On the other hand, if you are making aquery in Access which is using an SQL Server dB as a backend then it should be possible, exactly as you do if Access was used as the backend.

Hi Martens! Hows it going here?

Det går skam fint... jeg har lavet ODBC til SQL-serveren... og så kan jeg sagtens referere til formens feltnavne.... like form!form1.felt1 etc ....

men med *.adp virker dette ikke !

Hvad med et lille eksempel ????

med en ADP. der "snakker" med en SQl-server....

In an ADP a form has a records source exactly like an MDB database! So you can alter the record source in code.

Lets say you have an unbound field in the header of the form named txtSearch. Then you place a button beside the field so that when you press the button the form shows the records containing what you entered in the field.

In the buttons on click event  you would use something like this.


Me.Recordsource = "SELECT * from YourTable where SomeField Like '%" & Me.txtSearch & "%'"

You can also use the forms filter property.


Me.filter = "SomeField Like '%" & Me.txtSearch & "%'"
Me.filterOn = True

?

hvad med noget a´la dette :  = N'[SELECT * from tbl.categories where ProductName Like ''%] & forms.form2.txtSearch & [%'']'

Kan det lade sige gøre ?

eller dette : SELECT    CategoryID, CategoryName, Description, Picture
FROM        dbo.Categories
WHERE    (CategoryName LIKE N'forms.form2.textsearch')
i et view

the examples you give will as far as I know not work, and I work with Access (adp) and MS SQL Server every day at work.

Where EXACTLY do you want to use the SQL,in a form, a report or maybe just create a recordset?

hows it going, are we getting any closer to what you want?

martens>Time to close! Have you seen how long this qeustion has been open?

150 point og så er der ro :o)

:o)