G
Guest
i want the form to change to the language the user choses in a combo box. how
do i code that in vba?
do i code that in vba?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Graham R Seach
What you're asking for is not necessarily easy in Access, because Access
doesn't use resource files.
You'll have to code it yourself. What's more, you'll need to create a
resourcxe table, containing a ResourceID as the primary key, LanguageID, and
the translation for each language in your list. Exactly how you handle the
different languages depends on *what* you want to translate (labels or
data).
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
doesn't use resource files.
You'll have to code it yourself. What's more, you'll need to create a
resourcxe table, containing a ResourceID as the primary key, LanguageID, and
the translation for each language in your list. Exactly how you handle the
different languages depends on *what* you want to translate (labels or
data).
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
G
Guest
thank you so much for your response....i want to translate labels n data +
message boxes on a form.
the form is a standalone form
so you are suggesting that i create a table with the resourceid,language id
+ translation then link it to the main table. the main table will be exported
to access. if u have sample code pliz send it to me on
(e-mail address removed)
im desperate
message boxes on a form.
the form is a standalone form
so you are suggesting that i create a table with the resourceid,language id
+ translation then link it to the main table. the main table will be exported
to access. if u have sample code pliz send it to me on
(e-mail address removed)
im desperate
R
Ron2006
"translating the labels of the fields is no big deal. because you will
simply be replacing the caption property of all labels from one set of
characters to another sent of characters. in the on-current event of
the form.
I saw a posting of one person who "translated" dropdowns etc, by
baseing the queries of the dropdowns on tables that contained an ID,
english value, french value (or whatever) And then in the oncurrent
event he would change the column widths for all the combo boxes in the
oncurrent event to be 0;1;0 for english and 0;0;1 for english.
Obviously the bound column on those comboboxes was the ID.
The developer in the above case also changed the font from one language
to a different language.
Translating anything else that is not stricly controlled is a
significantly bigger task.
Ron
simply be replacing the caption property of all labels from one set of
characters to another sent of characters. in the on-current event of
the form.
I saw a posting of one person who "translated" dropdowns etc, by
baseing the queries of the dropdowns on tables that contained an ID,
english value, french value (or whatever) And then in the oncurrent
event he would change the column widths for all the combo boxes in the
oncurrent event to be 0;1;0 for english and 0;0;1 for english.
Obviously the bound column on those comboboxes was the ID.
The developer in the above case also changed the font from one language
to a different language.
Translating anything else that is not stricly controlled is a
significantly bigger task.
Ron
G
Graham R Seach
I don't have code for it, and although as Ron suggests, doing it for Labels
and so on, isn't all that hard, doing it for data is next to impossible.
One avenue you might consider, depending on how important it is for you, is
to use translation web services. I haven't use these translation web
services, but I know Google has them. I think if you're likely to go down
that track, you can forget about intrinsic connections to tables; everything
will have to be unbound. It won't be easy, so you really want to think about
it before embarking on such an exercise.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
and so on, isn't all that hard, doing it for data is next to impossible.
One avenue you might consider, depending on how important it is for you, is
to use translation web services. I haven't use these translation web
services, but I know Google has them. I think if you're likely to go down
that track, you can forget about intrinsic connections to tables; everything
will have to be unbound. It won't be easy, so you really want to think about
it before embarking on such an exercise.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia