Datetimerpicker VBA

Question

I am developing an application in Visual Basic, and would like to know how to load saved hours in the database for control DateTimePicker, I can normally insert the value into the database.

Format(TimeOfDay.ToString("HH:mm:ss"))

but I can’t recover the value in control.

Answer 1

Turning over the MSDN I found!

 Dim h As New TimeSpan
 h = bs_coleta.Current("coleta_horaColeta")
 DateTimePicker1.text = h.ToString

bs_collection is a Bindingsource that temporarily stores the data from the Collection table.