469,631 Members | 1,209 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,631 developers. It's quick & easy.

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 8093
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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Greg | last post: by
9 posts views Thread by Coleen | last post: by
1 post views Thread by zsolt | last post: by
1 post views Thread by nagi28 | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.