DTPicker for time without seconds for database

[Caro]

Does anyone know how I can use a DTpicker for just HH:MM to put in an Access database as a time field (I don't need the seconds)

[DatabaseLife]

Originally posted by Caro:
Does anyone know how I can use a DTpicker for just HH:MM to put in an Access database as a time field (I don't need the seconds)

I am working on trying to get the DTPicker to just give a date and that's it! I did it once but can't remember... I'll check it out once I get my &%@%& DataEnvironment to connect to my UDL.

[JHausmann]

Originally posted by DatabaseLife:
I am working on trying to get the DTPicker to just give a date and that's it! I did it once but can't remember... I'll check it out once I get my &%@%& DataEnvironment to connect to my UDL.

Check the value property?

[JHausmann]

Originally posted by Caro:
Does anyone know how I can use a DTpicker for just HH:MM to put in an Access database as a time field (I don't need the seconds)

Like?

dbTimeFld = "#" & DTPicker.hour & ":" & DTPicker.minute & "#"

[Caro]

Thanks - it's easy when you know how! Many thanks for help