Jun 09, 2009 06:33 PM|hans_v|LINK
I don't think you understood what you've read!
Dim objBegDate as Object
If BegDate.Text = "" Then
objBegDate = System.DBNull.Value
objBegDate = CType(BegDate.Text, Date).ToOADate() 'Convert a date to an Ole Automation Date when inserting dates to an Access database!
myCommand.CommandText = "insert into events_calendar(BegDate, EndDate, BegHour, Title, Details, EndHour, Email, Town, Province, Region, ContactPerson, PhoneNumber) values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
myCommand.Parameters.AddWithValue ...... (in total 12 parameters for all the questionmarks, in the same order as in the SQL query!)