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
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