Customize date format

[Guest]

I understand the issue with Y2K, but I wanted to format a date that reads
02/04/06. ACCESS did not provide a format for the aforesaid date format. How
does one customize the date formats so I can use 02/04/06 format in ACCESS?

 

[Rick Brandt]

I understand the issue with Y2K, but I wanted to format a date that
reads 02/04/06. ACCESS did not provide a format for the aforesaid
date format. How does one customize the date formats so I can use
02/04/06 format in ACCESS?

You can enter just about any format you want. You are not limited to what is in
the list. In your case just enter...

mm/dd/yy

 

[Guest]

I understand your mm/dd/yy response, but the main question is how can I add
it to the dropdown format list so I can it to a form so the user only has a
choice of mm/dd/yy?

 

[Rick Brandt]

I understand your mm/dd/yy response, but the main question is how can
I add it to the dropdown format list so I can it to a form so the
user only has a choice of mm/dd/yy?

Shouldn't matter. The format will be applied when the users leave the field
regardless of how they enter the date.

If you mean you want to show a list of dates in the desired format then use the
Format() function in the RowSource query for the ComboBox to make the dates in
the list look as you want.

=Format(DateField, "mm/dd/yy")

 

[Guest]

We don't connect with the English language very well! However, I'll' try one
more time with you, but if you dont' udnerstand my English "syntax," then
pass it on to somebody else who has a college degree and is not a High School
drop-out! (NOTE: Last week you did not udnerstand my question as well).

You stated: "Shouldn't matter. The format will be applied when the users
leave the field regardless of how they enter the date." The aforesaid
statement shows you did not udnerstand the question! It is self-evident that
if you put the correct format in a field, the regardless of what the user
places in a filed, it will format correctly! I DID NOT ASK THAT ENGLISH
QUESTION! Do you understand the aforesaid English!

The question again is: Go to TABLES, then DESIGN view, and then Right click
the data type, and then clcik format. In the aforesaid format the choice I am
seeking is not present! How can I add a new format of mm/dd/yy? Do you
undertsand that? The aforesaid same problem exist in the following procedure:
Select FORMS, then DESIGN view, and right click format. You get the same
problemspecifcially, the format mm/dd/yy is not available. Accordingly, the
user's input will not format to the aforesaid format.
Do you understand the aforesaid English language? Did you finish High
School or College? What College did you attend? Can you read and write past a
high school level and comprehend what you read? Are you a high school
drop-out?

 

[Tom Ellison]

Roy:

I do not believe you cannot change the contents of the list of formats for
date/time datatypes in table design. Same thing for Forms design. You can
type or paste the desired format if it is not in the list. Or, you can buy
out Bill Gates and have this changed. Your choice.

Those who answer questions here are volunteers. They are people who
volunteer their time for your benefit. They do not deserve any abuse.

Your original question doesn't even tell us what you want to know. It
refers to formatting a date "02/04/06". That is utterly ambiguous. There
are multiple possibilities to interpret this. It could be:

Feb 4, 2006 MM/DD/YY
Apr 2, 2006 DD/MM/YY
Apr 6, 2002 YY/MM/DD

All these are very prevalent date formats in various parts of the world. My
point is, your initial statement of the question is not clear. It doesn't
say anything about what selections are in the default list when you are
designing tables or forms, which is what you actually seem to want to know.
How could Rick or anyone else have known this?

This has nothing to do with what language you commicate in. It has to do
with whether you communicate in words what someone else could not possibly
guess without reading your mind. The initial failure to communicate was
clearly yours.

I beleive you should cool off and think about this. I took the time first
to give you a straight answer to what I can tell about your question.
Helping you realize that you must moderate your tone will be a big help to
you as well. It is not unlikely that the small number of us who spend time
nearly every day, including Rick, will not suffer such abuse repeatedly.
You would then be unlikely to get any help when you need it. This may be
more valuable to you than just answering this one question.

Please just take a look in the mirror to see what has transpired here. It
was you who initially failed to communicate!

Tom Ellison

 

[Duane Hookom]

Tom, as usual was much too kind in his reply.

 

[John Vinson]

In the aforesaid format the choice I am
seeking is not present! How can I add a new format of mm/dd/yy?

Put the mouse into the Format property field at the bottom left of the
screen.

Type the letter m twice, the slash key, the letter d twice, the slash
key, the letter y twice.

Save the table.

Your reply was grossly impolite, and I was unable to resist the
temptation to reply in the same vein.

John W. Vinson[MVP]

 

[Tom Ellison]

Dear Duane:

How very kind of you to say so!

Tom

 

[Tom Ellison]

My motivation in answering was not only for Roy's benefit, but Rick's. I do
not know Rick. But I know he hangs out here and has been helpful. I wanted
to possibly give him a bit of support. He deserves it. If he is
particularly sensitive, this would be good cause in my estimation. But I
want to do that without causing any additional ill will on anyone's part.

Those of us who "live" in these newsgroups don't like having a mess in the
living room.

Tom Ellison

 

[Duane Hookom]

I agree whole-heartedly. Rick Brandt is a HUGE asset in these news groups in
terms of both quantity and quality of his responses. He didn't deserve
getting blasted when his response wasn't much different from what I would
have provided.

 

[Tom Ellison]

Hey John,

In line. <grin>

Hope to see you again soon!

Tom Ellison

Put the mouse into the Format property field at the bottom left of the
screen.

I would prefer to move the mouse cursor on the screen, and not the actual
mouse. And, don't forget to click!

Placing the mouse on the screen gets in the way of seeing what is there.
Or, perhaps your mouse is really one of those old light pens. Still, I
think you have to click for this to be useful!

Here's another advanced option, the F6 key. It moves you right to the
FieldProperties area where the default focus is on the Format. Then Ctrl-V
to paste, F6 to return to the FieldName/DataType/Description area and on you
go! Since I thought Roy wanted a way to make his work quicker, this would
be a good way to speed things up.

Type the letter m twice, the slash key, the letter d twice, the slash
key, the letter y twice.

Well, if you have a lot of them to enter, I still like the Paste option.
That's probably a better shortcut even than having it in the list.

Save the table.

Your reply was grossly impolite, and I was unable to resist the
temptation to reply in the same vein.

You got that right! You certainly were unable to resist.

 

[Rick Brandt]

I agree whole-heartedly. Rick Brandt is a HUGE asset in these news
groups in terms of both quantity and quality of his responses. He
didn't deserve getting blasted when his response wasn't much
different from what I would have provided.

Well all I can say is wow! I take a couple hours to work on something else and
then find this when I return. Roy's response is so over the top that I my only
reaction was to be confused and amused. Clearly personal interaction is not his
strong point.

I thank you, Tom, and John for the kind words and support. As for Roy, well he
has my sympathies (and a warm spot in my kill-file).

 

[Tom Ellison]

Just in case, for any law enforcement types, a kill file is a list of email
or newsgroup sources from whom to hide posts, and has nothing to do with
homicidal intent.

I'm glad if you took this so well, Rick! It's good to make your
acquaintance! But don't forget Duane. He's another of the good guys.

Tom Ellison

 

[Rick Brandt]

Just in case, for any law enforcement types, a kill file is a list of
email or newsgroup sources from whom to hide posts, and has nothing
to do with homicidal intent.

I'm glad if you took this so well, Rick! It's good to make your
acquaintance! But don't forget Duane. He's another of the good guys.

Tom Ellison

Actually my reply was to Duane's post so he was covered by the "you" in my
previous message.

See this is just how these misunderstandings start ;-)

 

[Guest]

TO: JOHN W. VINSON (MVP - MVP - MVP - THE WINNER!)

Your response was on the mark! It worked correctly and was the actual
response to my question. You are the winner! Thanks for the excellent
response! Subsequently, Tom Ellison followed your response with a
supplemental addition that further defined your excellent response.

COMMENT TO ALL WHO RESPONDED: In life, we deal with "Schrondinger's Cat"
and "superpositions" constantly, unknown at the present time, but will become
the norm in the future! A question is not always a question, but a .... As in
Schrondinger's Cat, it is there, and then it is not there! If a question is
ambiguous, then ask questions to further define the issue! Last weekend
(January 28, 2006), Rick Brandt provided an answer to the Shrondinger's Cat
and showed his true position pertaining to a "superposition" of the .... Roy
A. Day sent a response this weekend (February 4, 2006) to Rick Brandt's
response from last weekend (January 28, 2006). Last weekend (January 28,
2006), John W. Vinson provided an excellent response to Roy A. Day's
Schrondinger's Cat question from last weekend (January 28, 2006), which the
aforesaid question from last weekened was ... ambiguous. Ironically, John W.
Vinson provided another excellent answer this weekend. If Roy A. Day had not
provided the "stimulating English language syntax" for the question for this
weekend (February 5, 2006) pertaining to the question on "mm/dd/yy," then
John W. Vinson would not have answered with the excellent, true, and correct
answer, and Roy A. Day would have been left with another Schrondinger's Cat
(now you see it, and now your don't), and with no true and correct answer.
Roy A. Day thanks each one for the ... responses, which provided an eventual
response from John W. Vinson (MVP - the WINNER).

For the record: Roy A. Day has no interest in law enforcement, and Roy A.
Day's has full and complete knowledge on what a kill file would be. The
problem we have is that law enforcement cannot read and write and comprehend
what they read, specifcially, they are the former high school thugs!

Pursuant to Tom Ellison's response that I should buy Bill Gates out and
then change the format field for dates, I am working on that issue, and
hopefully, Microsoft will have a new owner, and will become a proprietary
product (similar to Apple’s Steve Jobs projects).

Everyone should thank John W. Vinson for the excellent answer. Roy A. Day
will possibly see all of you next weekend.

 

[Marshall Barton]

This is ridiculous! Rick's very first response provided
exactly the same solution as John's tongue in cheek, but
highly praised, response. What the bleep has all the fuss
been about?

 

[Rick Brandt]

This is ridiculous! Rick's very first response provided
exactly the same solution as John's tongue in cheek, but
highly praised, response. What the bleep has all the fuss
been about?

To be fair, my response made assumptions. It assumed the user knew that entries
were made via the keyboard and it assumed that the user would know which keys to
press on the keyboard for the desired entry to be made.

 

[Marshall Barton]

To be fair, my response made assumptions. It assumed the user knew that entries
were made via the keyboard and it assumed that the user would know which keys to
press on the keyboard for the desired entry to be made.

You're right Rick. This whole stupid interchange was caused
by your omission of the critical information about what to
click on and which keys to strike. I'm guilty of not even
noticing that distinction. It's a good thing we have John
around to fill in the details :-\

 

[Tom Ellison]

Hey Marsh:

Yes! I knew John was good for something. Doesn't miss a keystroke.

Tom Ellison