How to create access-mdb with different languages support?

[Guest]

Hi!
I'm trying to build an ms-access application (mdb) with different languages
support. So the user can select the language that he want (understands) to be
displayed at all forms, queries, reports, messages etc. (Languages i mean:
English, Spanish, German, Italian etc! (not programming language). How can
this be done in one mdb, with some automation, i mean not to write a form 6
times for 6 different languages...

Thank you for helping
George X

 

[tina]

well, the only way i can think of is to create one or more lookup tables to
store the text you want to display for form/report captions, and
messageboxes. then, when each object (form or report) is opened, you'll need
code to loop through the controls and set caption properties from the
table(s) values. and code to select the appropriate text for messageboxes.

that handles what the user sees. if the forms will be used for data entry
rather than just data display, that's another issue. it might not be too
difficult to set up alternate language displays in combo box and listbox
controls, again using lookup tables to populate those; and perhaps requiring
code depending on how you set it up. but what about "open" textboxes where
your user enters data? of course s/he could enter it in any of the languages
you mentioned, but i'm thinking about how you may need to use that data
later in reports. to use a very simplified example: Yes, Si, Ja, and Oui
all mean the same thing, but it would take quite a bit of work to make
Access lump records with all four responses together and return a single
count of the number of records with an affirmative value in that field.

hth

 

[Guest]

Thank you for anwsering Tina

I thing this is a good idea (the first part of your message).
Now, i must writing the code...

Thank you for your help
George X