In Query auf Formular zugreifen

[c.thome]

Hi.

Ich habe folgende Frage:
Ich möchte aus meiner Query auf einen Wert im Formular zugreifen.
Folgendes habe ich versucht, das geht auch:

SELECT tbl_legal_entity.*
FROM tbl_legal_entity
WHERE tbl_legal_entity.NAME Like [Formulare]![frm_0_Main_Menu]!
[button_search_entity_name];

Mein Problem ist aber das ich den SQL-Befehl so machen möchte, dass er
mit LIKE "*abc*" sucht. Das funktioniert aber nicht, wenn ich im Query-
Designer bin. Wenn ich den SQL-Befehl per Hand fest eingebe, geht es:

SELECT tbl_legal_entity.*
FROM tbl_legal_entity
WHERE tbl_legal_entity.NAME Like "*Suisse*";

Es müsste eine Syntax geben, mit der ich trotz " und * auf das
Formular zugreifen kann.

Danke für Eure Antworten,
Christian

 

[Guest]

Despite not knowing German I am going to take a bold step. Try

SELECT tbl_legal_entity.*
FROM tbl_legal_entity
WHERE tbl_legal_entity.NAME Like "*[Formulare]![frm_0_Main_Menu]!
[button_search_entity_name]*";


But I could be completely wrong.

Can you type in English?

Danker

 

[Stefan Hoffmann]

hi,

SELECT tbl_legal_entity.*
FROM tbl_legal_entity
WHERE tbl_legal_entity.NAME Like "*[Formulare]![frm_0_Main_Menu]!
[button_search_entity_name]*";

[Formulare] is the German locale for the [Form] reference. He likes to
get a dynamic search, but I'm not sure what [button_search_entity_name]
in this context means (really a button)?

@Christian:
This is an English speaking newsgroup.

Try this one.

WHERE tbl_legal_entity.NAME Like "*" &
[Formulare]![frm_0_Main_Menu]![button_search_entity_name] &
"*";

btw, what kind of control is [button_search_entity_name]?


mfG
--> stefan <--

 

[c.thome]

hi,

SELECT tbl_legal_entity.*
FROM tbl_legal_entity
WHERE tbl_legal_entity.NAME Like "*[Formulare]![frm_0_Main_Menu]!
[button_search_entity_name]*";

[Formulare] is the German locale for the [Form] reference. He likes to
get a dynamic search, but I'm not sure what [button_search_entity_name]
in this context means (really a button)?

@Christian:
This is an English speaking newsgroup.

Try this one.

WHERE tbl_legal_entity.NAME Like "*" &
[Formulare]![frm_0_Main_Menu]![button_search_entity_name] &
"*";

btw, what kind of control is [button_search_entity_name]?

mfG
--> stefan <--

Hi

sorry, I hadn't recognized, that the group is in english.

I have tried both and then I have found my terrible mistake... the
solution of Stefan is working! Today I have seen, that it is not the
button_search_entity_name that i want to search, it is a field called
"entity_search_string", this is a string, not a button and with this
field, my query is working like it is described by Stefan.

Sorry for my stupid mistake, but I havn't seen it yesterday.

Thanks a lot for your answers.
Bye Chris