I know that this has had to come up before. Is there a safe way of determining that a string (like a last name) includes a " ' "? This, I know, will become a problem when logging in employees to my Access 2000 table.
Any suggestions?
Printable View
I know that this has had to come up before. Is there a safe way of determining that a string (like a last name) includes a " ' "? This, I know, will become a problem when logging in employees to my Access 2000 table.
Any suggestions?
Here is a snippit from one of my programs to solve this.
strCustomerName = Replace(rsCustomers!CustName, "'", "''")
rsCustomers.Find "CustName = '" & strCustomerName & "'"
I know it has been awhile, but I finally got to use the code yu supplied and it works great !!! Thanks once again.