Hi,
We have an Access Application which works fine for most of the users.
But there is one user who has the date input problem.
When he enter a date field from a form, i.e. 09/03/2004 (Sept. 3,
2004), the value always gets flipped into 03/09/2004(Mar 9, 2004) as
soon as the cursor leaves that date field.
When he enters 09/24/2004, the value doesn't get flipped.
My discovery is that any value in between '/' under 12 will be flipped.
The format for the field is Short Date. The sample for it is
'6/19/1994'.
The regional short date format setting from Control Panel is M/d/yyyy,
Date separator is '/'.
MS Access version is 2002 SP3 and it's running on Windows XP.
Any insight on this? It drives me crazy!
Thanks 4 7492
You're sure about the short date format on his machine? That's really the
only thing that's make sense.
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
<rz****@allstat e.ca> wrote in message
news:11******** *************@f 14g2000cwb.goog legroups.com... Hi,
We have an Access Application which works fine for most of the users. But there is one user who has the date input problem.
When he enter a date field from a form, i.e. 09/03/2004 (Sept. 3, 2004), the value always gets flipped into 03/09/2004(Mar 9, 2004) as soon as the cursor leaves that date field. When he enters 09/24/2004, the value doesn't get flipped. My discovery is that any value in between '/' under 12 will be flipped.
The format for the field is Short Date. The sample for it is '6/19/1994'. The regional short date format setting from Control Panel is M/d/yyyy, Date separator is '/'. MS Access version is 2002 SP3 and it's running on Windows XP. Any insight on this? It drives me crazy!
Thanks
I have seen this before on a server running ASP code. In this case I
went right through the registry looking at the Control Panel /
International settings. You need to be sure that every instance has
the country ID and the date formatting set the same.
This kind of thing is a lot more common for us Brits!
Phil
Sorry to reply a bit late.
The problem is not related to the registry since I check every entry
under International settings from registry.
The client machine is a regular desktop not a server. All what I did is
to open the table in design view and go through the date format again
which read the way as the registry stores.
I went back to the program and found that every date field is working
without flipping.
Don't know the reason yet. Is there Access local setting overriding the
system setting somehow?
Anyway I got it fixed eventually.
Thanks
RS200Phil wrote: I have seen this before on a server running ASP code. In this case I went right through the registry looking at the Control Panel / International settings. You need to be sure that every instance has the country ID and the date formatting set the same. This kind of thing is a lot more common for us Brits!
Phil
Access has a Format property, yes -- and it overrides the system when it is
specified.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Technical Lead
Globalization Infrastructure, Fonts, and Tools
Microsoft Windows International Division
This posting is provided "AS IS" with
no warranties, and confers no rights.
<rz****@allstat e.ca> wrote in message
news:11******** *************@l 41g2000cwc.goog legroups.com... Sorry to reply a bit late.
The problem is not related to the registry since I check every entry under International settings from registry.
The client machine is a regular desktop not a server. All what I did is to open the table in design view and go through the date format again which read the way as the registry stores.
I went back to the program and found that every date field is working without flipping.
Don't know the reason yet. Is there Access local setting overriding the system setting somehow?
Anyway I got it fixed eventually.
Thanks
RS200Phil wrote: I have seen this before on a server running ASP code. In this case I went right through the registry looking at the Control Panel / International settings. You need to be sure that every instance has the country ID and the date formatting set the same. This kind of thing is a lot more common for us Brits!
Phil This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Gerrit Holl |
last post by:
Posted with permission from the author.
I have some comments on this PEP, see the (coming) followup to this message.
PEP: 321
Title: Date/Time Parsing and Formatting
Version: $Revision: 1.3 $
Last-Modified: $Date: 2003/10/28 19:48:44 $
Author: A.M. Kuchling <amk@amk.ca>
Status: Draft
Type: Standards Track
|
by: Jay |
last post by:
I previously posted this question under Visual Basic
newsgroup, but was advised to re-post here.
I'm hoping someone can help me solve an issue I'm having
with VB.Net and Access 2000.
Here's the issue. I hope I've included all relevant
information.
On a form, I have a DateTimePicker with the following
|
by: Richard Hollenbeck |
last post by:
I'm trying to write some code that will convert any of the most popular
standard date formats twice in to something like "dd Mmm yyyy" (i.e. 08 Jan
1908) and compare the first with the second and calculate days, months, and
years. This is not for a college course. It's for my own personal
genealogy website. I'm stumped about the code. I'm working on it but not
making much progress. Is there any free code available anywhere? I know it...
|
by: Sean C. |
last post by:
Helpful folks,
Most of my previous experience with DB2 was on s390 mainframe systems
and the optimizer on this platform always seemed very predictable and
consistent. Since moving to a WinNT/UDB 7.2 environment, the choices
the optimizer makes often seem flaky. But this last example really
floored me. I was hoping someone could explain why I get worse
response time when the optimizer uses two indexes, than when it uses
one. Some context:
|
by: Peter James |
last post by:
Access 97
If I select New on the Query tab of the db window, and go staight to sql
view and type in the following for example:
INSERT INTO tblMyTable ( dtDate, txtAny)
VALUES (#2003-09-03#, 'blah');
and then save the query, close it, and then reopen by clicking the design
button so it opens in sql view. The sql has changed to:
| |
by: Edward S |
last post by:
I budget for a Project in an Excel sheet as illustrated below. The
months below are usually a 2 year period i.e. 24 months, though it
could be over 24 months depending upon a Project. I then need to
input this in an Access database, where I do a comparison with the
Actual cost. The table “TblBudget” in Access is made of 4
fields, namely: (1) CostElement (2) CostCenter (3) Month (4) Amount$.
At the moment this method is very cumbersome....
|
by: abcabcabc |
last post by:
I write an application which can let user define own date format to input,
How to convert the date string to date value with end-user defined date
format?
Example, User Defined Date Format as "dd/MM/yyyy"
input as "01082003" convert to date value as, 01 Aug 2003
Example, User Defined Date Format as "yyyy,dd,MM"
|
by: NH |
last post by:
I want to allow users to enter dates in a text box in either the US "MM dd
yy" format or the UK "dd MM yy" format.
But how can I validate these dates? All the date functions e.g. ISdate,
convert.ToDatetime etc fail on the US date format as the application and IIS
is set to UK format.
Its strange that the date format("12/03/06","MM dd yy") is interpretated
correctly but format("12/22/06","MM dd yy") bombs out.
|
by: saddist |
last post by:
Hello,
I've been working on access 2000 for few days. I made some forms with textfields where you can type date. Those textfields had input mask set for short date 99/99/0000. Now software have changed and some computers have access 2000 and some have access 2003, where date format is 0000/00/00. Is there some way for input mask to change depending on access version? I know the date format will convert from 2000 to 2003 (I don't know if it'd...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |