[AccessD] An International Consideration

To add to this unilateral discussion.

My French colleague tells me he could have used [Forms] rather than
[Formulaires] - the French version will accept French or English whereas the
English version only "speaks" English (how typical is that!). So the moral
is that if you're coding in another language and want your software to be
usable elsewhere use the English keywords (ok that's not so surprising).

But what I do find surprising is that my assumption that VB was all English
is wrong. The statement

Do Until .EOF
can be written in Franglais in the French version as
Do Until .Dernier

and, what's more, my English Access understands it!! Sacre bleu.

--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Subject: [AccessD] An International Consideration
Date: 10/04/08 08:34


Hi everyone

Here's a funny thing that's arisen because of running an Access system
written in French on an English version of Access. I thought those of you
involved in systems around the globe might be interested in this.

I found that when I open a form whose data is based upon a selection made on
the previous form Access pops up the parameter entry dialog and asks me to
enter the value which it ought to be just reading from the earlier form. So
say I'm in form A. There's a prompt for a week number and then a button to
open the production plan for that week. In France, where the system was
written, that week's plan would appear. Here in the UK Access pops up a
dialog asking for the week number and only when I enter it there does the
plan appear. This behaviour occurs all over the systems. What it is, I'm
sure, is that the recordsource for the planning screen is:

SELECT *
FROM [Pr?paration planning]
WHERE [Pr?paration planning].Semaine=[Formulaires]![Semaine
planning]![Semaine]

If you look at the WHERE statement the keyword Formulaires is not being
recognised in English Access (it would be Forms here of course) so
[Formulaires]![Semaine planning]![Semaine] is being treated as an unknown
parameter and Access asks for user input.

Interesting eh? Of course what I could do is get hold of a French version of
Access but I'd need to install that on another machine as it would be sure
to get in the way of the English version. A case for Virtual PC, I know.
Anyway this post is not about solving this (unless someone has a great idea
of course), more about pointing out yet another potential pratfall when you
cross national/language borders. I'd be interested to know if Access handles
the reverse ok, ie if [Forms] is used would that be ok in the French
version?

--
Andy Lacey
http://www.minstersystems.co.uk


________________________________________________
Message sent using UebiMiau 2.7.2

-- AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

________________________________________________
Message sent using UebiMiau 2.7.2