multilingual reports

[mveijndh]

How can I set up a multilingual report? I need to set this up in 4 languages. I need a table with translations, that's clear, but how do I best link the fields in the report with the translations?

 

[Ranman256]

I would have the reports using the language code in the name....
rData-ENG
rData-ESP
rData-RUS

The user would select the lang code at start, or during report selection.

 

[CJ_London]

but how do I best link the fields in the report with the translations?

do you mean the name of the field or the contents of the field?

 

[mveijndh]

That way I have to build each (I have many) report 3-4 times. I was looking for a single report solution, changing the contents based on the client language available in the query the report is based upon. This might be difficult, but that was the first goal.

 

[CJ_London]

please provide more detail to your question - do you have multiple translations of the same report? do you want to use something like google translate? What is to be translated - the labels/captions of controls? the contents of the controls? both?

 

[mveijndh]

Hi CJ,

What I think is the best way is I have a table with X coloums, ID, Dutch, English, French, German,.. Depending on the clients native language I take the data for that language. I don't want to change the database layout, just the data in the report. I prever I have a single report, not 1 for each language.

 

[Grumm]

I use a query with IIF(language='dutch',mytable.Dutch,IIF(language='English'....
Then i use that query in the report.

 

[CJ_London]

sorry - still not understanding what you are trying to do and what you currently have - perhaps provide an example

 

[mveijndh]

Hi CJ,

So far I have nothing, I still need to build it, I'm trying to do this one time good, so I'm trying to find out how I best set this up. I know the language the report has to be in. I just want to use 1 report meaning I build the report with phrases depending on language from a tblTranslation. I think a IIF could do this. I'll try to set up a small example to test it.

 

[CJ_London]

really depends on what your tbltranslation looks like and how it is used

I would suggest perhaps something like

tblTranslation
TranslationPK autonumber
PhraseNo integer/text
Language text
Phrase text/memo

then you can look up the phrase from an ID/No and select the language based on the computer language.

Look at the LC ID's here

https://msdn.microsoft.com/en-gb/goglobal/bb964664.aspx

 

[arnelgp]

you may want to study this one, for starter.
also note that when localizing, some text may be short or longer when localized, so you have to take care of this.

 

[mveijndh]

Hi,

I can't download the file, it sais attachemnet.php How can i get the file?

 

[CJ_London]

this is a problem with IE.

save the file then change the php extension to .accdb

Then you can open the file

 

[mveijndh]

Big Thanks!

 

[mveijndh]

Hi CJ,

Get an error in
Private Sub Report_Load()
Dim lcid As Long

lcid = GetUserDefaultLCID()

Me.Label0.Caption = getcaption(lcid, "Title")
Me.Label1.Caption = getcaption(lcid, "Name")
Me.Label2.Caption = getcaption(lcid, "Surname")
End Sub

It does not recocnize the sub or finction GetUserDefaultLCID()

 

[CJ_London]

question for arnelgp - he sent the file!

 

[arnelgp]

here is again the db

 

[mveijndh]

I get an error opening the database, no such Sub of Function on GetUserDefaultLCID()

 

[arnelgp]

what version of ms access do you have?

 

[mveijndh]

My version is Access 2016