I am using vb 2008, and i have successfully connected to access 2003 database using ado data control.
But I am unable to insert date and time and also retrieve it from data base.
The code which I use is
TO INSERT
recordset.fields("EntryDate").value= DateTimePicker.value
TO RETRIEVE
DateTimePicker.value=recordset.fields("EntryDate").value
It gives me errors.
Any suggestions will be appreciated
Thank you in advance
But I am unable to insert date and time and also retrieve it from data base.
The code which I use is
TO INSERT
recordset.fields("EntryDate").value= DateTimePicker.value
TO RETRIEVE
DateTimePicker.value=recordset.fields("EntryDate").value
It gives me errors.
Any suggestions will be appreciated
Thank you in advance