Query using english and french version of Access 2003

[Dave]

Hi,
I'm working on an application using Access 2003 English. My client is using
Access 2003 French. There is only one problem with this "cross-languages"
usage.
In Access English a parameter from a form in a query would be:
[Forms]![MyForm]!txtField1

In Access French a parameter from a form in a query would be:
[Formulaires]![MyForm]!txtField1

So the queries created in one language don't work in the other...

How can I overcome this problem?
Thanks,
David.

 

[Guest]

HI.

I also program my access database in English version an my clients have
Portuguese. I think there's no problem. Try to use this:

[Formulaires]![MyForm]![txtField1]

In my cases Access convert Forms into Formularios. If you note when cases
such like Between in portugueses is Entre so till now there's never been a
problem. Try.

But thanks. I'll have to create a program in English version to be used in
French version and i'll be carefull with that.

Regards,
Marco

 

[Michel Walsh]

Develop using the US version, if possible (accordingly to the local law,
that is). The French version will recognize the English words, but not the
reverse. FORMS!formName!ControlName will always work, but
FORMULAIRES!formName!ControlName will only work if your end user is using
the French version.

Vanderghast, Access MVP