Hi,
I have an application that has a "Notes" textbox where I want the user to be able to type anything they want.
The problem is that whenj I try to do an 'INSERT INTO' command I somtimes get the error "Syntax error (missing operator) in query expresion ....."
It only seems to happen when the user types special characters such as &^*(&*"$%"£$ etc...
I can't identify which one is causing the error and anyway I want the user to be allowed to type anything that the textbox will allow..
Can anyone help??
Cheers
I have an application that has a "Notes" textbox where I want the user to be able to type anything they want.
The problem is that whenj I try to do an 'INSERT INTO' command I somtimes get the error "Syntax error (missing operator) in query expresion ....."
It only seems to happen when the user types special characters such as &^*(&*"$%"£$ etc...
I can't identify which one is causing the error and anyway I want the user to be allowed to type anything that the textbox will allow..
Can anyone help??
Cheers