Ok, I'm having problem on how to save texts with quotes.
Let's say I'm saving a value in a textbox like O'Neil.
That's where I receive an error.
How do I save names or texts like O'Neil or texts with qoutes?
Here's my code for saving:
With RecSet .Open "Select * from EmpRecord", DBLink, adOpenDynamic, adLockOptimistic .AddNew .Fields("Name") = txtName.Text .Update MsgBox "Record has been Saved", vbInformation
Edited 5 Years Ago by abelingaw: n/a