DateTimePicker to DB Access

[powerteh]

Hi,
Thi is the sample form that i want to create.
Problem :
i) how to save the text box value together with the DateTimePicker values into a same table, as a same record? (by clicking the button)

Please show me simple example of code if its need DataBinding to achieve.

thanks

 

[albertkhor]

Dim SQL as String
 
SQL = [SIZE=2]"INSERT INTO TableName (Name,AccessDate) VALUES (' " & TextBox1.Text & " ', ' " & DateTimePiucker.[SIZE=2]Value.Date.ToString[/SIZE]() & " ') "
[/SIZE][SIZE=2] 
[/SIZE]

 

[powerteh]

hi,
thanks for your code!
Now i can continue my assignment.