Query using english and french version of Access 2003

  • Thread starter Thread starter Dave
  • Start date Start date
D

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.
 
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
 
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
 
Back
Top