Language Problem

[kruger101]

Hi all,

I have searched this forum but it's almost impossible to get what I am looking for...

I've designed a database that gets modified and upgraded daily. The problem I have is that the Form I use to enter data should be available in 3 languages. All I want to know is: Is there some or other way I can have 1 Form and still have 3 different languages? EVERYTHING should be changeable into the other language... any ideas?

At the moment I have 1 set of Tables, 1 set of Queries and 3 sets of Forms (for the 3 languages). I'd like to change it to 1 set of Forms, but still have all 3 languages.

Please help!?

Thanks a lot.
I appreciate all input.
kruger101

 

[KenHigg]

Why do you have to modify the design of the form everyday? Sounds like you may high level design issues...

 

[BobJones]

Have a form with three buttons saying for example...

English

French

Spanish


When you click the English button it does this...

    DoCmd.openForm "YOURFORMNAME", , , , , , "English"

and for French...

    DoCmd.openForm "YOURFORMNAME", , , , , , "French"

Then in the onLoad event of the main form put this...

If Me.OpenArgs = "English" Then
	ChangeLabels  'Either make a Sub to change all your labels to another language, eg Label1.Caption = "Hello"
	ShowLabels 'Or you can have three sets of Labels and just set the visible properties of them personally I'd just change the label captions
ElseIf Me.OpenArgs = "French" Then
	ChangeLabelsFrench
ElseIf Me.OpenArgs = "Spanish" Then
	ChangeLabelsSpanish
EndIf

Thats how I'd do it.
Next time, don't post three topics exactly the same, its annoying and takes focus of other peoples topics who still haven't been answered!

Regards Bob

 

[MStCyr]

You could check the bilingual sample app that I have poseted some time ago.

http://www.access-programmers.co.uk/forums/showthread.php?t=103594