Changing MS Office language breaks the application

[Ray Cacciatore]

I used the French version of MS Access to develop a French Access
application. Everything works well, if my users have the Microsoft Office
language set to French. One of my users had this set to English and the
application "almost" works well. The only thing is that all the
"Forms!MyForm!MyControl" text that I set in property sheets get translated to
"Formulaires!MyForm!MyControl" by French Access when I exit the field. Of
course, this is not recognised by English Access.

Even when I use the query builder, the built-in functions like DCount, DSum
all get translated into the French versions when I exit the individual fields.

My question is this:
Since French Access can translate the English text to French, why can't the
English translate it back to French. I'm speaking at the level of the
property sheet and/or query builder. Shouldn't the property window
automatically translated it back?

VBA is VBA behind the product so the code modules always have
"Forms!MyForm!MyControl" I don't need to type it in French. After all there
is no French VBA. But I'm wondering why my application does not work in both
languages. All the user has to do is change the MS Office language on his
computer and boom, my application fails.

Ray

 

[dbahooker]

if you were using an Access Data Project; I think that it would be a
LOT easier to manage

-aaron

 

[Pieter Wijnen]

This (in my humble view idiotic) feature of all non-us office products to
change the code to use local terms for keywords, means that all development
has to be done using the US version of Office as all other versions are
compatible with the US version but not with other versions (which I've
always preferred anyway).

Pieter

 

[Ray Cacciatore]

If I understand what you're saying is: If I developed the application using
the U.S. version, then it would work if I open it in other versions without
any problems?

 

[Pieter Wijnen]

correcto

Pieter

If I understand what you're saying is: If I developed the application
using
the U.S. version, then it would work if I open it in other versions
without
any problems?

 

[Ray Cacciatore]

....and if I develop it using a French version of Access, it won't work in the
Englsih version. Right?

 

[dbahooker]

keep your logic on the database side; keep the VBA side in english.

have a simple table that lists captions for your forms and reports;
it's a pretty basic concept isn't it?

the problem is that you're using VBA functions; instead of SQL Server
functions.

Use Access Data Projects; it's a whole lot simpler.
you keep your databases objects on the server instead of having 100
different copies

-Aaron