If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to disable @ parsing?
Hi there,
when using MyForm.recordsource="SELECT * FROM products WHERE prodcode='Screws@8' " I get a message box asking for "Input parameter value 8". How can I disable the parsing of the @ symbol to allow searching for fields with the embedded @ symbol? Any idea would help Stephan -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200611/1 |
#2
|
|||
|
|||
How to disable @ parsing?
Have you tried putting the @ symbol in brackets?
prodcode='Screws[@]8' You'll have to check fo the @ symbol before you formulate the string: If InStr([Field],"@")0 then... Replace([Field],"@","[@]") Stephan_Cz wrote: Hi there, when using MyForm.recordsource="SELECT * FROM products WHERE prodcode='Screws@8' " I get a message box asking for "Input parameter value 8". How can I disable the parsing of the @ symbol to allow searching for fields with the embedded @ symbol? Any idea would help Stephan -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200611/1 |
#3
|
|||
|
|||
How to disable @ parsing?
Hi kingston
yes, I've tried brackets, yet it does not help. Instead the right bracket becomes part of the question: Input parameter value ]8 Cheers Stephan -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200611/1 |
#4
|
|||
|
|||
How to disable @ parsing?
Try creating a string variable:
strVar = "Screws@8" Then create the SQL string: "SELECT * FROM products WHERE prodcode='" & strVar & "'" Stephan_Cz wrote: Hi kingston yes, I've tried brackets, yet it does not help. Instead the right bracket becomes part of the question: Input parameter value ]8 Cheers Stephan -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200611/1 |
#5
|
|||
|
|||
How to disable @ parsing?
"Stephan_Cz" u28860@uwe wrote in message news:6907271f411c0@uwe
Hi there, when using MyForm.recordsource="SELECT * FROM products WHERE prodcode='Screws@8' " I get a message box asking for "Input parameter value 8". How can I disable the parsing of the @ symbol to allow searching for fields with the embedded @ symbol? I'm guessing this is an ADP problem, and I don't have one handy to test. But would it work if you wrote this: MyForm.recordsource = _ "SELECT * FROM products WHERE prodcode='Screws'+'@'+'8' " ? -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
Thread Tools | |
Display Modes | |
|
|