LOST you suggestion to escape erro with apostroph in insert

[sal21]

Sorry me Hans, but changed my pd and lost all youy preciuos suggestion!

How to inser or update recordset where the value in question have apostroph?...

i remember only to replace a var with:

my_var=replcae(my_var,???????????)

example my_var="d'amico"

tks as usual.

[HansV]

Depends on how you're going to use it.

[sal21]

Depends on how you're going to use it.

Here si a difference in insert or update query?

[HansV]

If you create an SQL string in VBA with apostrophes / single quotes around text values, you need to replace apostrophes within those text values with two apostrophes:

Code: Select all

my_var=replace(my_var,"'", "''")

[sal21]

If you create an SQL string in VBA with apostrophes / single quotes around text values, you need to replace apostrophes within those text values with two apostrophes:

Code: Select all

my_var=replace(my_var,"'", "''")

Sorry to reply in old post...
but,

now have my_var=valle d'aosta
I use the tips in question when i see the record in field i have:
valle d''aosta.!!!!!!!!!!!!!!!

note:
Ths field is in txt format

[HansV]

Please post the SQL you're using.

[sal21]

Please post the SQL you're using.

resolved my self.. tks in other case.