Search results for query: *

Thanks, I got the code to be working fine with no error. However, I have one stupid question. This is my first time working with parameter, therefore, I'm not familiar with "Connection String" yet. In the past, I use the connection by choose the "OleDbDataAdapater" from the toolbox and then...

I try that but when I added the date, using your format, I check my MS access table and the date field listed some date that is invalid. The date is listed as "6,24,1904", and some field is listed as "12/30/11899". What's going on here. Help me please :)

Friend, I have a question about date conversion. I'm coding a SQL INSERT query in VB.NET platform. The code work just fine and the date conversion work just fine also. I use MS Access database to store the data. I setup the "Dates" field in MS Access as Date/Time with short date format. I...

Thanks, However, I'm not able to get the code to work when adding the [] to the code. Would you please give me some example using my code listed in the thread? Thanks

Hello Friend, I have a problem writing a string into a MS Access database. The code is in SQL but the platform is in VB.NET. Below is my code. OleDataAdapter.InsertCommand.CommandText = _ "INSERT INTO Expense(Amount, Dates, Debit, Credit, " & _ "ExpenseType, PaymentMethod, Summary) " & _...

Thanks, I will try that when I got home from work today. Again, thanks for your help. Any other comment or advice would be appreciated.

Hello friend, I have a problem with my coding that drive me nut for the past three days. Hope someone can help me. The code is first, I update the current existing record from a database. I use the SQL UPDATE query to update the record after searching for it from an access database. After...