I need to filter an ADO recordset by the name of a company that contains more than one apostrophe in their name. Even though I replace the single apostrophes with double apostrophes my code errors out. Help.
Printable View
I need to filter an ADO recordset by the name of a company that contains more than one apostrophe in their name. Even though I replace the single apostrophes with double apostrophes my code errors out. Help.
Can you post the statement that your using?
David Paulson
Hi there ,
I don't kmow if this will help, but I started using the accent ` chr(96) instead of the single quote '
Visually it looks the same and I use the Replace() func to screen incoming records to convert B4 saving to the DB.
Thanks RobZ