Senin, 09 April 2012

RE: [MS_AccessPros] Entering time

 

Glen,

I might try a combo box. Not exactly as you mentioned but similar. I
really do not need all 24 hours in a day.

How about another question related to time. I have to enter start time and
stop time. The stop time is always 1 hour after the start time. Is there
any way to make the stop time default to the correct time after the start
time is entered. I am able to make default numbers but I am getting mixed
up with trying to make a default time period.

Thanks for any help you can offer.

Bill Singer

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Glenn Lloyd
Sent: Monday, April 09, 2012 10:40 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Entering time

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%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill
Singer
Sent: April-09-12 11:20 AM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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]

_____

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2411/4924 - Release Date: 04/09/12

[Non-text portions of this message have been removed]

__._,_.___
.

__,_._,___

Tidak ada komentar:

Posting Komentar