472,811 Members | 1,644 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,811 software developers and data experts.

Unwanted American date format problem

Hi there,

I'm having a problem with my database changing the date that I enter in
the format dd/mm/yyyy into American format. Bizarrely, when enter the
date in a textbox it changes round, but if I change the format of the
textbox from short date to medium or long date, the date appears as it
is supposed to.
I also have a calendar control in another form that is linked to a date
field in a table. When you choose, say 3rd August, it appears as 8th
March in the underlying table.

All the regional settings etc are correct and everything has been
double-checked, and access is the only program this happens in.

Has anyone experienced similar?

Thanks- David

Nov 13 '05 #1
5 8191
See:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

The article explains how the interface (forms, tables, criteria in query
design) uses the Regional settings (assuming you leave the Format property),
but that literal dates in SQL statements and VBA code are interpreted as the
American format.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Daveo" <wr**********@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
Hi there,

I'm having a problem with my database changing the date that I enter in
the format dd/mm/yyyy into American format. Bizarrely, when enter the
date in a textbox it changes round, but if I change the format of the
textbox from short date to medium or long date, the date appears as it
is supposed to.
I also have a calendar control in another form that is linked to a date
field in a table. When you choose, say 3rd August, it appears as 8th
March in the underlying table.

All the regional settings etc are correct and everything has been
double-checked, and access is the only program this happens in.

Has anyone experienced similar?

Thanks- David

Nov 13 '05 #2
Hi Allen,

It appears that the problem shows on only one PC and the rest in the
office are fine an work as desired. They're all on XP Pro and Access
2000.

Thanks - David

Nov 13 '05 #3
Hi Allen,

It appears that the problem shows on only one PC and the rest in the
office are fine an work as desired. They're all on XP Pro and Access
2000.

Thanks - David

Nov 13 '05 #4
Where you have one PC acting differently than the rest, and you are certain
the regional settings (Windows Contol Panel) are the same, it would be worth
checking that it is running the same version of Office 2000 (SP3?), and
especially the same version of JET (SP8?).

Help | About will give you the Access version.

Locate msjet40.dll (typically in windows\system32).
Right-click and choose Properties.
On the Version tab, you should see 4.0.8xxx.0 if it is SP8.
If not, get Jet 4 update:
http://support.microsoft.com/gp/sp

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Daveo" <wr**********@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

It appears that the problem shows on only one PC and the rest in the
office are fine an work as desired. They're all on XP Pro and Access
2000.

Thanks - David

Nov 13 '05 #5
Where you have one PC acting differently than the rest, and you are certain
the regional settings (Windows Contol Panel) are the same, it would be worth
checking that it is running the same version of Office 2000 (SP3?), and
especially the same version of JET (SP8?).

Help | About will give you the Access version.

Locate msjet40.dll (typically in windows\system32).
Right-click and choose Properties.
On the Version tab, you should see 4.0.8xxx.0 if it is SP8.
If not, get Jet 4 update:
http://support.microsoft.com/gp/sp

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Daveo" <wr**********@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

It appears that the problem shows on only one PC and the rest in the
office are fine an work as desired. They're all on XP Pro and Access
2000.

Thanks - David

Nov 13 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Ian | last post by:
I have a problem I hope someone can point out where I am going wrong. I need to store a date/time in a cookie ( ie the date a visitor last visited ) However the date format changes to US, despite...
2
by: Greg | last post by:
Isn't the following date format supposed to work with any installation of MySQL? YYYY-MM-DD HH:NN:SS It's not working on one system... the date is shown as all zero's.
8
by: Ishbel Kargar | last post by:
Since upgrading from old laptop (Windows 98) to new laptop (Windows XP), my mail-merge letters are doing strange things with date formats. For instance, my reminder letter for lapsed subs carries...
9
by: Coleen | last post by:
Hi all :-) I have a bit of code that chacks for the last day of the Month, and if it falls on a week-end, sets the due date to the Monday after... I'm trying to get the date to go to the...
1
by: zsolt | last post by:
Hi, I'm trying to convert a string to date by specifying the format. The value is like this: "03rd of April 2006". Now this is converted fine by using the following format: "dd\r\d \o\f MMMM...
7
by: mewanalwis | last post by:
Dear Friends, I have a rather strange problem which invloves SQL server and ASP. The problem is this. I have an ASP application which use a SQL server. it saves date values with MM/dd/yyyy...
1
by: cableguy69 | last post by:
Hello There. I am programming with visual basic within the Excel realm. I have a problem with the way my selected textbox recognizes dates generated from the datepicker. I am from New...
1
by: nagi28 | last post by:
Hi All, I am executing a select query which involve join between three tables through jdbc. I am using MS-ACCESS as database. This query needs to get the data based on some conditions on date...
1
by: Maciej07 | last post by:
Hello, We are using SQL server 2000 on W2k Server and MS Access 2000 ADP (like front-end). Now we try to change operating system for SQL Server 2000 from W2k to W2k3 and we found problem with...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.