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
only time...

Recommended Answers

Change line 6 and 13. My psychic powers tell me the problem is there.

Jump to Post
Dim tmData as Date
tmData  = format (DatePicker1.Value, "Short Time")
Jump to Post

All 5 Replies

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"

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.