[AccessD] Developing European Applications

Don't forget about European date order and the date and time separator 
symbols
can vary from country to country. Also you may have to download the MS 
Euro font
symbol to your development site. German for example increases caption 
and label
sizes by about 30%. You may run out of screen real estate.

Here is a book on the topic, out of print but amazingly used copies
are selling for double the original retail price.

Internationalization with Visual Basic By Michael S. Kaplan
650 pages, w/CDROM
ISBN: 0672319772 

Site for used copies and Table of Contents and sample chapters.

http://www.i18nwithvb.com/

Kaplan did a lot of work on Access,  wrote the wizards for 97
then went independent, now he is back as project  lead  on
 MS Internationalization effort.
 Here is his MS blog

http://blogs.msdn.com/michkap/default.aspx

Rocky Smolin at Beach Access Software wrote:

>Paul:
>
>After ending up with 5 versions of a DOS-based system to support - one for
>each language - I made the Access version multi-language in the rewrite.  I
>have two tables - one for controls (basically labels and command button
>captions), the other for message boxes.  To add a language, I just add a
>column to each table and send the tables to whoever is doing the
>translation. The biggest problems I ran into was with the Unicode stuff -
>like the simplified and traditional Chinese.  
>
>I ended up with a few translation routines in a module - there are some
>tricky differences translating controls on reports versus forms and sub
>versus main.  I translate everything in the op open event and there's no
>apparent lag except sometimes with the Chinese on a slower system.
>
>HTH
>
>Rocky
>
>-----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 3:25 AM
>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
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada