Category Archives: Microsoft Access

Replace Function Doesn’t Replace Double Quotation in VBA

13-11-2012 I had to remove all double quotation marks from a string using VBA. I tried to do this by using the Replace function as shown below. Also Note that two double quotation marks are used to represent the quotation mark. This is because the quotation mark is a special character in VBA and weContinue reading “Replace Function Doesn’t Replace Double Quotation in VBA”

Is Order Of OleDbCommand.Parameters Important

01-08-2012 The order of the parameters collection of an OleDbCommand must match the order to which those parameters appear in the SQL statement. Otherwise the .net framework will try to fill the parameters in your SQL statement according to the order of parameters in the OleDbCommand.Parameters collection. This can cause an Data type mismatch inContinue reading “Is Order Of OleDbCommand.Parameters Important”