I'm creating an INSERT statement from the text fields in a form. This is a snippet:
mySQL = mySQL & Combo0 & "','" & Text3 & "','" & Text5 & "','" & Text7
I am alternating the double and single quotation marks to enclose the entire statement as a single STRING while using the single quotation marks for the individual text fields. However, these fields are names and addresses and if there is anything like "O'Brien" or "Marc's" then the entire statement fails because of the extra quotation mark. I've tried using "Chr(34)" but once they are in a STRING that's how they stay. Any help would be appreciated
Software/Hardware used: MS Access 2007, Windows Vista
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!