Use of the " ' " sign

[sven2]

Hello,

when I save some information in my database with a string like this:

strSQL = " UPDATE Personeelsfuncties SET Status = '" & [Forms]![FrmPersoneel]![cboStatus] & "', "
strSQL = strSQL & " Hoofdfunctie = " & [Forms]![FrmPersoneel]![chkHoofd_functie] & " "
strSQL = strSQL & " WHERE (Personeelsnummer = " & Me.txtPersoneelsnummer & ") "

iIt goes wrong when I use the " ' " sign.

The reason for this is that access stops the string at this sign.
How can I solve this problem so that I can use the " ' " sign in textfields?

Thanks in advance,
Sven.

 

[Ron_dK]

iIt goes wrong when I use the " ' " sign.

You might try this instead : "'"

 

[sven2]

What I mean is that when I execute the SQL and the field status = "EHBO" everything works, but when status = "EHBO'ers" it goes wrong.

 

[Ron_dK]

What I mean is that when I execute the SQL and the field status = "EHBO" everything works, but when status = "EHBO'ers" it goes wrong.

Then you might use "EHBO*" in your field status.

 

[Dennisk]

there are ways around this using double quotes or the CHR() function.

 

[MSAccessRookie]

Hello,

when I save some information in my database with a string like this:

strSQL = " UPDATE Personeelsfuncties SET Status = '" & [Forms]![FrmPersoneel]![cboStatus] & "', "
strSQL = strSQL & " Hoofdfunctie = " & [Forms]![FrmPersoneel]![chkHoofd_functie] & " "
strSQL = strSQL & " WHERE (Personeelsnummer = " & Me.txtPersoneelsnummer & ") "

iIt goes wrong when I use the " ' " sign.

The reason for this is that access stops the string at this sign.
How can I solve this problem so that I can use the " ' " sign in textfields?

Thanks in advance,
Sven.

Where does it go wrong? I am sure that you are aware that the " ' " denotes the start or end of a Text String. In your example above, the strSQL should work if:

• Status is a Text Field, and [Forms]![FrmPersoneel]![cboStatus] contains a Text Value.
• Hoofdfunctie is a Numeric Field, and [Forms]![FrmPersoneel]![chkHoofd_functie] contains a Numeric Value.
• Personeelsnummer is a Numeric field and Me.txtPersoneelsnummer contains a Numeric Value.

Are all of these true? If not, then the query will need to be adjusted to account for any differences.