Trouble with Data entry with the name starting with O'B...

  • Thread starter Thread starter Rocky
  • Start date Start date
R

Rocky

Don't know where to look, but had this problem before. With names like
"O'Brien"? Getting a Syntax error #3077 ( Access database seems like it
doesn't like the apostrophe character ('). Any solution to this problem?
 
Don't know where to look, but had this problem before. With names like
"O'Brien"? Getting a Syntax error #3077 ( Access database seems like it
doesn't like the apostrophe character ('). Any solution to this problem?
Click to expand...

Use " as a delimiter in your query (which you dodn't choose to post...)
instead of '; or use Replace([namefield], "'", "''") to replace all
apostrophes with two consecutive apostrophes prior to inserting.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

quiero comprobar mi correo electronico 1
Foolproof Query on Quote and Apostrophe Text? 1
Names in input masks using apostrophies 2
Apostrophe Error in LastName 3
Apostrophe / single quote / Chr$(39) in a name 4
Removing apostrophe from text entry 4
Error 3075 when entering Irish style last name 11
Combo Box Error 3077 - Access 2003 1

Back
Top