I have an Access97 database(on Win95 machine) which connects to a POP3 server and downloads email generated by a web site. One of the bits of information I can get is the date from the email message header, which I receive as text. I want to convert this to date format so Access can manipulate it.
Normally I would say e.g. CDate("13 Oct 1999") and have no problems. BUT I am working in Brazil and most people here have Office installed in Portuguese (however, some have English). Microsoft being clever-boots that it is, has translated EVERYTHING into Portuguese, even built-in functions. The CDate in Portuguese Access does not understand English date formats (October = Outobre in Portuguese, it is expecting "13 Out 1999" instead). However the date information is taken from the email header info, which is controlled by the ISP server, which is in English format and beyond my power to change.
I want to put in a check that looks up whether the user has Portuguese or English Access installed, and then either converts the date to Portuguese via a function, or leaves it alone. Something like this:
select case (whatlanguageofAccessdoesthiscomputerhave)
Does anybody know how to look up what language Access is installed in? It's gotta be a property somewhere but I can't find it.