Does anyone know of an interactive Clock to be used in forms?

[Nick]

Hi Developers,
I would like to build in a clock to be used to input starting and
ending times. The clock could either be the traditional round clock
or--think of a horizontal, graduated bar with times increasing from
left to right. Here is some other desired functionality:

--users could click a field, pop up the clock, then click a start
time, the time would be input into the form;
--users could click a field, pop up the clock, and then click an end
time, and/or;
--users could click a field, pop up the clock, and then click starting
and ending times, or drag to select a time range, times would be input
into both the starting and ending fields.

The clock would only need the 7:00 am to 3:00 pm range.
Reason why: much data is entered after-the-fact, so time-stamps are
exactly useful.

Just wondering if anyone has done something similar.
Thanks,
Nick

 

[Bob Quintal]

m:

Hi Developers,
I would like to build in a clock to be used to input starting and
ending times. The clock could either be the traditional round
clock or--think of a horizontal, graduated bar with times
increasing from left to right. Here is some other desired
functionality:

--users could click a field, pop up the clock, then click a start
time, the time would be input into the form;
--users could click a field, pop up the clock, and then click an
end time, and/or;
--users could click a field, pop up the clock, and then click
starting and ending times, or drag to select a time range, times
would be input into both the starting and ending fields.

The clock would only need the 7:00 am to 3:00 pm range.
Reason why: much data is entered after-the-fact, so time-stamps
are exactly useful.

Just wondering if anyone has done something similar.
Thanks,
Nick

Starting with the concepts exposed in Brendan Kidwell's DatePicker,
( http://www.glump.net/software/microsoft_access_date_picker )
I built a form with 2 columns for hours, 1 for 10's of minutes and 2
colums for minutes.

HOURS MINUTES
1 2 0 0 1
3 4 1 2 3
5 6 2 4 5
7 8 3 6 7
9 10 4 8 9
11 12 5 AM PM
xx y zz ap

Clicking on a button loads the value into the respective textboxes
xx, y zz and ap.
Clicking AM or PM converts the strings to a time value and sends it
to the calling form

 

[Jeanette Cunningham]

Hi Nick,
here is a sample you can download from
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=48&Number=1454249



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Nick]

Thanks!