PDA

Click to See Complete Forum and Search --> : DTPicker for time without seconds for database


Caro
Feb 15th, 2000, 10:42 PM
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
Feb 15th, 2000, 10:53 PM
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
Feb 16th, 2000, 12:48 AM
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
Feb 16th, 2000, 12:50 AM
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
Feb 16th, 2000, 01:30 AM
Thanks - it's easy when you know how! Many thanks for help