Replacing double-quote with empty string (Access 2003)

Topic

New Reply

Hello,

I have the following SQL that updates a field containing a single double-quote with an empty string. I can get this to work in a query window, however when I try doing the SQL in VBA, it doesn’t work. Does anyone know what I’m doing wrong?

CurrentDb.Execute “UPDATE TLoc_Agile_MPN SET TLoc_Agile_MPN.MPNStripped = Replace([MPNStripped],””””,”)”

Thanks in advance for your help.
Drew

Reply | Quote

Replies

Try

CurrentDb.Execute "UPDATE TLoc_Agile_MPN SET TLoc_Agile_MPN.MPNStripped = Replace([MPNStripped],Chr(34),'')"

Reply | Quote

Hans,

After posting this, I had found that I could use…
CurrentDb.Execute “UPDATE TLoc_Agile_MPN SET TLoc_Agile_MPN.MPNStripped = Replace([MPNStripped],'””‘,”)”

However, your approach is much less confusing. Thank you for your help, it’s greatly appreciated!

Reply | Quote