'Insert the New receipt Dim SQL As String = "Insert into Receipts (ReceiptDate,ReceiptTotal) values ( :1)" Dim CMD1 As New OleDb.OleDbCommand CMD1.Connection = Myconnection CMD1.Transaction = CustomerTrans CMD1.CommandText = SQL CMD1.Parameters.AddWithValue(" ", Now.Date) CMD1.Parameters.AddWithValue(":1", TotalPriceTxt)
i AM Using Access 2007 and I set t
ANY HELP GIVEN IS HIGHLY APPRECIATED. i TRIED ALMOST ALL I CAN THINK OF.
Thanks for the quick response. Although I have learned something new in the article you posted, I still can't find what the problem is with my code. What am I doing wrong? it looks valid syntax to me, but what do I know, I am new to this. I have been reading about INSERT INTO statement all day long and can't find whats wrong with my code.
You're more familiar with what exactly you are doing. Typically, names aren't allowed to start with a digit. My experience with Access (via OleDb) is that question marks (?) are preferred, but that names can be used if they're kept in order (as yours are). I have also only see a colon (:) used for parameter names in Oracle.
I was just guessing, based on the fact that there would generally be a comma separator in such expressions. However, from the further messages it seems that OP had not checked the documentation for proper format of the command.