Seting a date AND time in one control

[DukeLeto7]

So I'm working with a simple Access 2010 database at home to track my productivity on a coding project, and that means a table with start and end times.



Simple to do in table, harder to implement in form.

What I'd LIKE to be doing is using the DateTimePicker ActiveX control to specify a date and a time within the same control bound to a single field. This doesn't seem to be possible as designed though. One instance of the DateTimePicker can set a date or a time, but NOT both. Googling yields little of value as anything discussing 'date time and datetimepicker' is parsed as a search redundancy.

I can't be the only person to have dealt with this though.

Right now, my solution is somewhat kludgy, there are two DateTimePicker controls bound to the single table datetime field, and one displays and allows you to set the date and one allows you to set the time. It's kludgy because they have a tendency to overwrite each other non constructively. (ie. You change the date in DTPicker1, but this does not update the table when change focus to DTPicker2 to mess with the time, which is still bound to the table field and is hiding a copy of the old date, and the old date is reset from DTPicker2's value. So the behavior is you change DTPicker1 from '1/25/2015' to '1/24/2015', click on DTPicker2 to modify the time, and find the DTPicker1 displays '1/24/2015' again when you're done.)

Playing with the CustomFormat field has proved worthless.

Has anyone found a more elegant solution to dealing with a date and a time in the same table field on one form? My latest idea is to split the table fields, and I really hate it.

[orange]

Can you use the Now() function?

[DukeLeto7]

Can you use the Now() function?

Not practically. I'm generally editing a single record with a start time and an end time at once. The end time would generally correspond to the output of now(), but not always, and there'd be rounding.

[orange]

There are several date/time pickers in the demo here that can be downloaded. May be more than you need.
Found via google.

[DukeLeto7]

There are several date/time pickers in the demo here that can be downloaded. May be more than you need.
Found via google.

Yes, that does look like what I need, thank you.

For future reference, what were the Google search terms you used to find it?

[orange]

As I recall, I used utteraccess calendars and clocks