Changing a language 1

[jay2502]

I have Created a database in english I now have to have it in english and portugese (only front end) how would be the best way to do this with the user choosing his preferance.
I thought of copying all the forms translate it and have an option some where to change it between the languages.
Is this the only option or can anyone come up with some thing better.

 

[duGly]

My best solution would be to have the language preference stored in a field in some table, accessible by an option button on a form. Then create an Form_Open or Report_Open event handler for each form and/or report that needs to be translated.

In the open event, set the captions and/or ControlTip for each control that needs to be variable. For example,

Select Case strLanguage
    Case "English"
        Me.Caption = "Hello."
        lblX.Caption = "Where can I get a taxi?"
        lblY.Caption = "Will you help me with my bags?"
        lblZ.Caption = "Please stop at the next corner."
    Case "Portuguese"
        Me.Caption = "Alo."
        lblX.Caption = "Onde posso arranjar um taxi?"
        lblY.Caption = "Pode me ajudar com as malas?"
        lblZ.Caption = "Por favor,pare na proxima esquina."
End Select

(Please excuse the cheesy example; I'm sure you have much more informative captions in mind.)

Making your changes in code will eliminate doubling the file size for having copies of each form and report. It will also make editing much easier since you only have to edit one object, rather than duplicating your changes for each language.

[red]— Artificial intelligence is no match for natural stupidity.[/red]