I want to insert from the form text information which contains single quote (') and Double quote("") in the table. we usually write
insert into table (field1) values ('" & textbox1.value & "')
this format '" & textbox1.value & "' allows me to pass value in double quote ("") like henry""jones but doesnot pass value like henry'jones.
it pos up run time error 3075. Please can any one tell me how to pass both single quote and double quote values.