Charlotte Foust
cfoust at infostatsystems.com
Wed Jun 20 10:55:31 CDT 2007
A bigger potential problem is handling dates and delimiters in other languages. It can get especially dicey if you have to communicate BETWEEN languages. Number handling gets crazy when a comma is used as the decimal delimiter and dots or spaces are used to group the numbers. Those are the ones we've fallen over many times. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of paul.hartland at fsmail.net Sent: Wednesday, June 20, 2007 4:35 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Developing European Applications Importance: High Erwin, Many thanks for that, I think I have enough to go on for the short term....The application we have I have taken over for the last three years, it wasn't the best to start with, and have never had the time given to me to totally rebuild it, although when I do get the odd half hour to spare I am developing my own version, and it may not be too tricky to change this, for multilingual support etc. Once again many thanks Paul Message Received: Jun 20 2007, 12:10 PM From: "Erwin Craps - IT Helps" To: "Access Developers discussion and problem solving" Cc: Subject: Re: [AccessD] Developing European Applications Hi Paul I'm from Belgium and have some experience with that in Access. I got my musterd years ago from the ATM sample application in VB5/6 thats give a good demonstration how to do that. You gonna need to programmatic replace the captions by a text coming from a table that you load into a collection when opening the app. You can do this by setting some code or number in the tag property (as I do in Access) or use some kind of coding to name your controls. This does slow down the loding of forms but it is unnoticable if have have a normal amount of controls on your forms. Further more it is best to have a table or registry sayying which language to use for that specific user. Do not base yourself to the windows language or country settings because that is not ideal. Please take note that Netherlands Dutch and Belgian Dutch are technicaly the same language bur there is a serious difference in the choice of words. Iow if you want to be pa pro, you gonna need a Belgian dutch and a Netherlands dutch version. And don't forget 40% Of belgian is French speaking. So if this client is for instance located in Brussel, you gonna need the ability to have French and Dutch (and probably English to) depending on the logged in user. A Lot of Multinational companies in Belgium do force English as the software language, so maybe you don't need the translation. >>> should ask the customer. THIS IS IMPORTANT: Both Dutch and French are longer languages. You should pay attention to the lenght of your controls (captions, Titles etc) because Dutch and French are by average +/- 40 % longer then English. This can be problematic if you did not developped with that in mind. An other issue is paperformat. In europe mainland we tend to use A4 instead of lettre or legal. If your reports are based on lettre, you should not have a problem because it is shorter then A4, you could have complaints of the "green" guys telling you thats a waste of paper. Legal is longer than A4 and you could run into problems. For what concerns showing data based on a field, that is a tough one. You gonna need to have multiple extra fields in product desciptions etc etc for each language you use. This wil result in some major reprogramming. I don't know what kind of app you have, but there is in Belgium also some legal issues conernign use of languages on official documents like an invoice. For instance it is forbidden if you are a Flemisch (Dutch) Company to send a French Invoice to a French customer that lives in the French part of Belgium. If you do that this document is illegal and has no juridic value for a court. But thats the theory... If any other questions go ahead an shoot. Greetings Erwin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of paul.hartland at fsmail.net Sent: Wednesday, June 20, 2007 12:25 PM To: accessd; dba-vb Subject: [AccessD] Developing European Applications Importance: High To all, We have a visual basic 6.0 FE, connecting to a SQL Server 2000 database which all works perfectly well. However we are moving towards putting our Belgium & Netherlands offices onto the system. What I need to know is how to make my labels/controls/reports etc appear in the local languages, I would assume this is no easy task but if someone could point me in the right direction I would be very grateful. Thanks in advance for any help on this. Paul Hartland paul.hartland at fsmail.net 07730 523179 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com Paul Hartland paul.hartland at fsmail.net 07730 523179 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com