Hi,
I need to provide a copy of an Access database to a
person in Germany. Previously, they have had difficulty
with some of the monthly crosstab reports. Two or three
of the monthly columns do not show any numbers. Does the
German version of Access require you to reprogram for the
German translation of the monthly abbreviations?
as a german person, using german localised Access versions, i found out, that
"NORMALLY" the switch from an english/US to a german version is not very
problematic. Vice verca it isn´t always the case <g>
There following areas are typically the most problematic:
a) Dates
b) Numbers
a) Dates --- this is the most problematic area.
1) The written month and weekday names are different.
2) CDate and format works totally different sometimes.
3) In Germany the Date-default is DD.MM.YYYY (Day first, then month dot as
delimiter)
4) The same date may have a different week-number, depending, if week is
calculated in US or in Germany
as the correct parameters over here are vbfirstFourDays and vbMonday as
parameters for the format (and weekday) statement.
6) The first day of week is monday here.
7) The default date-delimiter is "." (dot) and the time-delimiter is ":"
(colon)
Month names
Januar
Februar
März
April
Mai
Juni
Juli
August
September
Oktober
November
Dezember
Weekday
Montag
Dienstag
Mittwoch
Donnerstag
Freitag
Samstag
Sonntag
The automatic Date conversion of c(v)date does not always work flawlessly over
here. The use of the Format-statement also may be problematic. I personally
would avoid the use of "written" month-names as CDate etc. has problems in that
area. Best bet here is to avoid CDate and Format-statement and Month- or
"written" weekday date-names at all and to try to calculate everything with
serialdate and Serialtime (if possible).
b) Numbers (and currency)
Numbers sometimes are problematic as well, as the delimiters here are vice
versa as in US.
one million is ober here written as follows: 1.000.000,00
The val statement is problematic.
Good thing for you is here, that the direct input numbers in VB are written
in english/US notation not in the german one. <g>
Of course there are other areas (menues etc.) where it could be problematic as
well, but they don´t matter so much in that case here, i think....
