Bill,
It might be easier just to let the user enter the time. However you could
use two or three unbound comboboxes, one for the hour, one for the minute
and one for am/pm (or you could use option buttons for am/pm. For the row
source of the hours combo use a table with 24 records and for the minutes, a
table with 60 records. Use the after update event of the three controls to
calculate and store the time (this is a rare exception to the rule about not
storing calculated results.
Glenn
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Singer
Sent: April-09-12 11:20 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Entering time
I have a field that is formatted as a date/time field. The user has to put
in a time like "11:00 PM". I am wondering if there is a easier way to
enter time than typing the whole number. All of the other information in
the record is selected from combo boxes but at this point the user has to
move to the keyboard. Is there a way to pull up a menu that allow the user
to select a time?
I suppose I could create a table to reference in a combo box but the number
of records would be huge.
Bill Singer
MN
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar