Using the code below, everything works well until one of the CompanyName values have an apostrophe in it.
VBA generates an error.
For Example: CompanyName = "John's Plumbing Supplies"
How can I modify the code to be able to update the CompanyName Field in Access when the string has an...