Unwanted American date format problem

[Daveo]

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

[Allen Browne]

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

[Daveo]

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

[Daveo]

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

[Allen Browne]

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

[Allen Browne]

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