Prev: Error "You cancelled the previous operation"
Next: gggggfhgdfgkjkasdflzslkjdhfg
From: Bob on 8 Mar 2006 20:56
Access 2003/Input Masks/Military Time:

I would like to create an input mask in Access to format military time. The
standard long time mask requires an AM or PM be added after the time is
entered. I have tried to just use "99:00:00" and this doesn't seem to be the
answer. I also intend to do calculations for elapsed time from two time
inputs. I hope the formate will allow for a simple subtraction of one from
the other. I also hope I don't need to reset my computer to military time to
accomplish this.
From: John Nurick on 9 Mar 2006 02:21
Hi Bob,

In most cases input masks are more trouble than they're worth. Assuming
you're talking about a control bound to a Date/Time field, the best
approach IMHO is instead to use a format of
hh:nn:ss
a validation rule of
Is Null Or (>=0 And <1)
to ensure that only times between midnight and just before midnight can
be entered (as opposed to dates), and validation text something like
this
Enter a time between 00:00:00 and 23:59:59
..

Doing it this way means that everything is displayed in military time
but the user has more flexibility in how to enter it.

On Wed, 8 Mar 2006 17:56:06 -0800, Bob <Bob(a)discussions.microsoft.com>
wrote:

>Access 2003/Input Masks/Military Time:
>
>I would like to create an input mask in Access to format military time. The
>standard long time mask requires an AM or PM be added after the time is
>entered. I have tried to just use "99:00:00" and this doesn't seem to be the
>answer. I also intend to do calculations for elapsed time from two time
>inputs. I hope the formate will allow for a simple subtraction of one from
>the other. I also hope I don't need to reset my computer to military time to
>accomplish this.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

From: Bob on 9 Mar 2006 20:12
John: Thank you for your reply. I am a newbee, and don't understand some
things in your response. What is IMHO? (Not in Help) When you say "use a
format", where do I format within Access? I didn't see that option (on a
quick look) in the tool bar, as it is in Word and Excel, or in field
properties on the design view.

I also notice you a "titled" MS Access person. Are you available to work on
projects? If not can you point me in a direction where I might find a
mentor, and/or contractor who can complete a data base to my specs?

"John Nurick" wrote:

> Hi Bob,
>
> In most cases input masks are more trouble than they're worth. Assuming
> you're talking about a control bound to a Date/Time field, the best
> approach IMHO is instead to use a format of
> hh:nn:ss
> a validation rule of
> Is Null Or (>=0 And <1)
> to ensure that only times between midnight and just before midnight can
> be entered (as opposed to dates), and validation text something like
> this
> Enter a time between 00:00:00 and 23:59:59
> ..
>
> Doing it this way means that everything is displayed in military time
> but the user has more flexibility in how to enter it.
>
> On Wed, 8 Mar 2006 17:56:06 -0800, Bob <Bob(a)discussions.microsoft.com>
> wrote:
>
> >Access 2003/Input Masks/Military Time:
> >
> >I would like to create an input mask in Access to format military time. The
> >standard long time mask requires an AM or PM be added after the time is
> >entered. I have tried to just use "99:00:00" and this doesn't seem to be the
> >answer. I also intend to do calculations for elapsed time from two time
> >inputs. I hope the formate will allow for a simple subtraction of one from
> >the other. I also hope I don't need to reset my computer to military time to
> >accomplish this.
>
> --
> John Nurick [Microsoft Access MVP]
>
> Please respond in the newgroup and not by email.
>
>
From: John Nurick on 10 Mar 2006 02:27
Bob,

As well as the InputMask property, Access fields and textboxes have a
Format property. It's not formatting in the sense of fonts and bold or
italic, but (like the NumberFormat property of Excel cells) controls how
a number or date is displayed.

In Table Design view, the Format property appears immediately before the
InputMask property.

In Form Design view, select the textbox, make sure the Properties sheet
is displayed, and you'll find the Format property on the Format tab.

I'm not available for contracting work, but someone else who reads this
may be.

On Thu, 9 Mar 2006 17:12:27 -0800, Bob <Bob(a)discussions.microsoft.com>
wrote:

>John: Thank you for your reply. I am a newbee, and don't understand some
>things in your response. What is IMHO? (Not in Help) When you say "use a
>format", where do I format within Access? I didn't see that option (on a
>quick look) in the tool bar, as it is in Word and Excel, or in field
>properties on the design view.
>
>I also notice you a "titled" MS Access person. Are you available to work on
>projects? If not can you point me in a direction where I might find a
>mentor, and/or contractor who can complete a data base to my specs?
>
>"John Nurick" wrote:
>
>> Hi Bob,
>>
>> In most cases input masks are more trouble than they're worth. Assuming
>> you're talking about a control bound to a Date/Time field, the best
>> approach IMHO is instead to use a format of
>> hh:nn:ss
>> a validation rule of
>> Is Null Or (>=0 And <1)
>> to ensure that only times between midnight and just before midnight can
>> be entered (as opposed to dates), and validation text something like
>> this
>> Enter a time between 00:00:00 and 23:59:59
>> ..
>>
>> Doing it this way means that everything is displayed in military time
>> but the user has more flexibility in how to enter it.
>>
>> On Wed, 8 Mar 2006 17:56:06 -0800, Bob <Bob(a)discussions.microsoft.com>
>> wrote:
>>
>> >Access 2003/Input Masks/Military Time:
>> >
>> >I would like to create an input mask in Access to format military time. The
>> >standard long time mask requires an AM or PM be added after the time is
>> >entered. I have tried to just use "99:00:00" and this doesn't seem to be the
>> >answer. I also intend to do calculations for elapsed time from two time
>> >inputs. I hope the formate will allow for a simple subtraction of one from
>> >the other. I also hope I don't need to reset my computer to military time to
>> >accomplish this.
>>
>> --
>> John Nurick [Microsoft Access MVP]
>>
>> Please respond in the newgroup and not by email.
>>
>>

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

From: Douglas J Steele on 10 Mar 2006 06:16
Since John didn't answer this question, I'll jump in.

It's an acronym for "In My Humble Opinion"

You may want to book mark a site like http://www.acronymfinder.com/ to help
with things like this.

HTH*

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Bob" <Bob(a)discussions.microsoft.com> wrote in message
news:91668D0B-E501-422D-9B0F-5DEAF557FD11(a)microsoft.com...
> John: Thank you for your reply. I am a newbee, and don't understand some
> things in your response. What is IMHO? (Not in Help)



* Hope That Helped


 |  Next  |  Last
Pages: 1 2
Prev: Error "You cancelled the previous operation"
Next: gggggfhgdfgkjkasdflzslkjdhfg