Dates regional settings

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having a problem with users entering USA formatted
dates on my system mm/dd/yyyy instead of my desired
dd/mm/yyyy for the UK. Obviously the regional settings
are set to American rather than UK.

Does anyone have some simple code I could use on start up
of my system which would read the PCs current regional
settings - and if not set to UK would not let the user
continue any further until corrected. I am assuming the
change is recognised by Access intstantly without having
to reopen Access.

Or alertatively is there code to ensure a date is always
in UK format or does the formatting in access only change
the appearance of a date - not the actual value that is
written to a database.

Will this solution work on any operating system - 95
onwards.

Thanks for any help --- Paul
 
I am having a problem with users entering USA formatted
dates on my system mm/dd/yyyy instead of my desired
dd/mm/yyyy for the UK. Obviously the regional settings
are set to American rather than UK.

Does anyone have some simple code I could use on start up
of my system which would read the PCs current regional
settings - and if not set to UK would not let the user
continue any further until corrected. I am assuming the
change is recognised by Access intstantly without having
to reopen Access.

Or alertatively is there code to ensure a date is always
in UK format or does the formatting in access only change
the appearance of a date - not the actual value that is
written to a database.

Will this solution work on any operating system - 95
onwards.

You do need to (nor should you) mess with the user's regional settings.
These only affect the "named" formats like "Short date", "General Date",
etc.. Just use an explicit format string like "dd/mm/yyyy" and that is how
they will be displayed regardless of the user's regional settings.
 
Back
Top