When searching for a particular Employee I would use a SQL string as such .....

Code:
strSQL = "SELECT * FROM Employees " & _
         "WHERE Surname = '" & strSurname & "'"
What do I do if the strSurname has a single quote in it?

eg....

Code:
strSQL = "SELECT * FROM Employees " & _
         "WHERE Surname = 'O'Sullivan'"
Any help would be appreciated.