Results 1 to 2 of 2
  1. #1
    kzoli62 is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    2

    Coding question

    First of all, let to introduce me. I'm Zoltan Kovacs from Hungary. I do as hobby and for friends Database programming, but I'm not a professional.



    I have questions:

    1. I do multilingual databases. To change the labels on the forms, I solved with one dictionary table. But, how can I get back the records in different languages. (See next sample

    GagT english german hungarian
    1 Attribute Marker Jelző
    2 Caliper Schiebelehre Tolómérő
    3 Depht Tiefenmesser Mélységmérő
    4 Drill Bohrmesser Furatmérő
    5 Lathe Grundmesser Fenékmérő
    6 Master Blocks Musterblock Mintahasáb
    7 Micrometer Mikrometer Mikrométer
    8 Mill Freser Maró
    9 Plug Körbe Dugó
    10 Scale Masse Méret
    11 Thread Schraube Csavar
    12 Tooling Werkzeug Szerszám
    13 Torque Drehmoment Nyomaték

    2. In Calendars like Your sample with Sub, how can I insert records to the selected Date, will be visible later in the Calendar? And maybe also in reports?

    Please help me to solve this questions, then I can help my friends too.

    BR

    Zoltan Kovacs

    PS.: PLS put me a mail on kzoli62@gmail.com too, if you have any solution for me.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    For a Lookup table with Languages,
    I would not do this
    1 Attribute Marker Jelző
    2 Caliper Schiebelehre Tolómérő
    3 Depht Tiefenmesser Mélységmérő
    4 Drill Bohrmesser Furatmérő
    5 Lathe Grundmesser Fenékmérő
    6 Master Blocks Musterblock Mintahasáb
    7 Micrometer Mikrometer Mikrométer
    8 Mill Freser Maró
    9 Plug Körbe Dugó
    10 Scale Masse Méret
    11 Thread Schraube Csavar
    12 Tooling Werkzeug Szerszám
    13 Torque Drehmoment Nyomaték

    I would suggest a structure such as

    Tablename

    ID
    LangCd
    LookupName
    with individual records such as

    1 eng Attribute
    1 ger Marker
    1 hun Jelző

    and I'd have the Id + LangCD as the PK. This structure facilitates adding a new language.

    also I'd suggest using ISO 639 as the LangCd values.
    see http://www.loc.gov/standards/iso639-2/

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Schedule Conflict Coding
    By mann2x in forum Programming
    Replies: 5
    Last Post: 10-08-2010, 09:52 AM
  2. Active Directory coding
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-28-2010, 08:33 PM
  3. Combo Box Coding
    By Hale in forum Forms
    Replies: 2
    Last Post: 05-04-2010, 10:56 AM
  4. Button Coding
    By yamie in forum Programming
    Replies: 3
    Last Post: 02-22-2010, 10:45 AM
  5. Bar-Coding
    By texasprincess7 in forum Access
    Replies: 1
    Last Post: 02-12-2009, 10:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums