|
| 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
November 9th, 2006, 01:07 PM
posted to microsoft.public.access.forms
|
|||
|
|||
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
November 9th, 2006, 01:36 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
November 9th, 2006, 01:56 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
November 9th, 2006, 02:19 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
November 10th, 2006, 03:19 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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 | |
|
|
Linear Mode
