[AccessD] Dealing with single quotes and double quotes at the sametime

John Skolits askolits at ot.com
Wed Nov 1 14:01:46 CST 2006


In the past I have used CHR$(34) for a double quote and CHR$(39) for a
single quote.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Rojas
Sent: Wednesday, November 01, 2006 2:37 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Dealing with single quotes and double quotes at the
sametime

Hello,

If I construct a string in VBA that contains the following string:
1' 5"

How could I update a field using DoCmd.RunSQL?
I know how to handle this if the string only contains a single quote OR
a double quote but not if the string contains both.

Thanks,
Joe Rojas
IT Manager
TNCO, Inc.
781-447-6661 x7506
jrojas at tnco-inc.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list