Systen default date settings

[Sandy H]

Hi
I hope someone can help me with this.

I have developed a database for an international organisation who have
offices in Australia, UK and USA. It is a membership database that relies
heavily on dates in many areas. We have just encountered a problem when the
USA version is used. The system has been developed in Australia and when a
log file is generated it records the date of the log without the user seeing
that date. It works fine in the UK and Australian versions but when a log
file is created in the USA, a date such as 4th June 2005, is actually
recorded in the table as 6th April 2005.

Without changing the code on every date field in the system, does anyone
have any other suggestions as to how I might fix this problem. I thought
that maybe I could change the default system settings when the database is
opened and then change them back when the database is closed. I'm not sure
how to do this but I assume it would work.

Thanks in advance
Sandy

 

[Douglas J. Steele]

In my opinion, we as developers have no business changing user settings.
Remember: yours will not be the only application running, and changes such
as date formats will impact all running applications.

For a solution, check out Allen Browne's "International Dates in Access" at
http://members.iinet.net.au/~allenbrowne/ser-36.html
or what I have in my September 2003 Access Answers column for Pinnacle
Publication's "Smart Access" newsletter. (The column and accompanying
database can be downloaded at
http://www.accessmvp.com/djsteele/SmartAccess.html)

 

[Sandy H]

Thanks for the information Douglas. I can't seem to access either of those
links on either of my computers.

Sandy

 

[Douglas J. Steele]

Well, I'd forgotten that Allen moved his site to
http://allenbrowne.com/ser-36.html but the link I posted worked for me just
now (and I know my link is correct), so I suspect the problem is either with
your computer or your ISP.