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 … Continue reading

Posted in General Computing, Microsoft Access | Tagged , , , , , , , , | Leave a comment

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 … Continue reading

Posted in C#.Net, Microsoft Access | Tagged , , , , , , , , , , | Leave a comment