Am using date time picker control in vb 6 to show time but when i try to store that in a access database it stores the default can somebody help me make it modify to store
Change line 6 and 13. My psychic powers tell me the problem is there.
Dim tmData as Date tmData = format (DatePicker1.Value, "Short Time")
Thanks nut its not working i think am clear of the doubt i have ita juat i want show only time in dypicker want to disable default value..
set the format type of DatePicker1 to custom
and set the format to hh-mm-ss
Check out the documentation on the Date Time Picker Control.
You have four different property values for format on the Date Time Picker control: use either dtpTime or dtpCustom as mentioned previously.
If you use dtpCustom, then you have to add runtime code to set the custom format for the control: e.g.,
dtpPicker1.CustomFormat = "hh:mm:ss"