I am new to this forum and I would like to get your help. I am having issues with this code.
HERE is the error I am getting: Syntax error (Missing Operator) in Query expression ' :1
Dim CustomerTrans As OleDb.OleDbTransaction = Nothing
Dim MyConnection As OleDb.OleDbConnection = Nothing
'Creat connection and the transactions Object
MyConnection = New OleDb.OleDbConnection(My.Settings.dbConnectionString)
CustomerTrans = Myconnection.BeginTransaction
'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)
i AM Using Access 2007 and I set t
ANY HELP GIVEN IS HIGHLY APPRECIATED. i TRIED ALMOST ALL I CAN THINK OF.
Thank you in advance.