How to search a string contains '

  • Thread starter Thread starter Lucy
  • Start date Start date
L

Lucy

The Client Name in a Contacts list contains a '. When use
Find("[ClientName] = '" & sClientName & "'"), it caused
syntax error. What's the right way to do it.
 

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

Connect to SQL 2005 database on local network fails 10
Linking Outlook mailing to Excel data lists 1
Firefox Multi-Account Containers 1
Messenger Won't Send to Localhost 2
Controlsource won't let Dlookup to enter 12
Open form "Client Details" by clicking "CientName" txtBox 3
Transferring parameters 13
Simple form + VBA code not working 2

Back
Top