Question Language issue in Access

[Mgomp]

Hi all.

I am writing a program on my own private version of Access 2010, which are in norwegian language. But the users of this program are using a (international) / US / UK version of the Access 2010.
When they start using my program, serverel "windows" in the new menu system will not load, and with others, they got the messagebox with the question: Missing value in... (a the adress the the object like:[Forms]![Navigeringsskjema]![NavigationSubform].[Form]![cboExportSystem])

As You se, in the above "link" - it is using Form and Forms. But in the norwegian version, creating queries, using the Build to insert parameters in the query - the norvegian word of Form and Forms are inserted (Skjema and Skjemaer) In all other ways, Access automaticly use the Form and Forms. (Cutting and past to VBA will automaticly make this translation"

First, I manually translated all the querys to use Forms and Form, but still I got severel error when using the uk / us version of Acces 2010

Why does this happend?

On Access 2003 (I skipped 2007), there was not any problems like this. I made apps on my norvegian version, and run the apps on uk / us version of Access 2003 without any big problem. Well, i know there have been some minor issue, but not like this.

I know there is a way to define language and related, but I don't know how to fix this issue.

Any good idea?

Regards.

 

[Mgomp]

The Language in this case, where not the problem. It seems like it, because when entering into stored queries and changed the norwegian words to uk/us, the error seem to disapear.

But the real problem is the stored queries it self. In all windows which I have problems, I have to open each query in query designer, select one field. Then when closing the query I save the "changes". No, the windows using this query will work.

So now I am running through all queries for all form/windows and all Comboboxes/list just open and the close with save..

is there anyone who can understand why this problem happens?

Regards

 

[JANR]

Yes refrences like Skjema!frmSomething!txtSomething will not work on non scandinavian version of Access.

If you use the wizzard to point to controls then in yours and mine version you'll have to replace skjemaer/skjema with forms/Form afterwords.

I found out that myself when I tested a db on a runtime 2010 enviroment, which isen't released in Norwegian.

JR

 

[Mgomp]

Well, this is just half way.

The real problem is when using the new menu system in Access 2010.
I have several "forms" which have querys as datasource. When moving the app from one PC to an another PC, somethings happen to the query.
The "forms" shows up blank - no info, no labels, no notihing.
When I open the source query for the form. select a field name (not change), and then click close - with saveing - then the form will show up when I start the app again. This happens with all window which have a query as a source. The problem occurs in querys with or without use of any criteria.

I have tested this with both the norwegian version and the us / uk version with the same result. Even betwen several pc with the us / uk version installed.

What do I do wrong? Using a query as a datasource for a form is the way I have done for some time now.

Regards