Programatically set XP regional settings to UK

[Mark]

Hi All,
By default, our machines regional settings are set to US which causes
problems with date formats until they are manually changed to UK. Is there
any way to set the regional settings to UK when the database is opened?

We work with the format dd/mm/yyyy not mm/dd/yyyy
OS = XP pro
Access Version = 2002 SP3

TIA

Mark

[David Schofield]

On Mon, 21 Mar 2005 15:52:40 GMT, "Mark" <ma**********@ntlworld.com>
wrote:

Hi All,
By default, our machines regional settings are set to US which causes
problems with date formats until they are manually changed to UK. Is there
any way to set the regional settings to UK when the database is opened?

Can't answer this one but ----
We work with the format dd/mm/yyyy not mm/dd/yyyy

----- if you use a date in an SQL string, it MUST be in US format, ie
mm/dd/yyyy.

If you need a date in code you can always use an alpha format eg
CDate("1 January 2005") which is the safest in my opinion.

I think the web site of one of the regulars has some handy tips on
using dates in Access but I can't lay my hands on it at present.

David

[David Schofield]

PS:
http://allenbrowne.com/ser-36.html is what I was thinking of.
David

[Trevor Best]

David Schofield wrote:

If you need a date in code you can always use an alpha format eg
CDate("1 January 2005") which is the safest in my opinion.

Strictly in code, not for outside world though. I once thought I was
safe exporting dates with the month spelt but was caught out when my
client was running it and the dates came out with the month names in
Turkish. The other end trying to import the data was a bit miffed :-)

--
This sig left intentionally blank