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)
Printable View
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.Quote:
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)
Check the value property?Quote:
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.
Quote:
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 & "#"
Thanks - it's easy when you know how! Many thanks for help