How to work with data containing ' ?

  • Thread starter Thread starter eti
  • Start date Start date
E

eti

The ' mark is in the name of a person. When I tried to search the name (using
combo box), the below message appear....

Run-time error '3077':
Syntax error (missing operator) in expression.


Example Data (Name of person): Jo'tong Umbula

Thank you.
 
eti said:
The ' mark is in the name of a person. When I tried to search the name (using
combo box), the below message appear....

Run-time error '3077':
Syntax error (missing operator) in expression.


Example Data (Name of person): Jo'tong Umbula

Thank you.
Click to expand...

This is a common problem for anyone working with any kind of SQL
databsae. You need to sanitize your strings before the little Bobby
Tables get to your database. ;) (but even if he did, it's OK- Access
doesn't support multiple statements so there's no chance of him dropping
your tables)

Few possible approaches:

1) Double up the apostrophe/quotation marks
2) Use a parameter query and insert into a parameter which always
handles this string
3) Strip it out and compare to the similarly stripped string from a
query (I'm not big fan of this approach)
 
The ' mark is in the name of a person. When I tried to search the name (using
combo box), the below message appear....

Run-time error '3077':
Syntax error (missing operator) in expression.


Example Data (Name of person): Jo'tong Umbula

Thank you.
Click to expand...

Use " to delimit the name in your combo box's AfterUpdate event, rather than
'. If you would like help doing so, open the combo box in design view; view
its properties; and copy and paste the AfterUpdate event code to a message
here.
 
Back
Top