Results 1 to 4 of 4
  1. #1
    Potatohead is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2013
    Posts
    4

    Greek Language Help

    Hi,



    I have an Access 2010 database that contains addresses that I use for generating invoices.

    I got an order from Cyprus today and the address is in Greek.

    I can save the record ok with the Greek characters but when I open the report to print the invoice the Greek characters show as question marks.

    I use a module to clean up addresses, I'm not really a programmer and I scavanged the code for it off the internet.

    The code is pasted below.

    From what I can gather I may need to use Microsoft Forms 2.0 Object Library. I can find the dll for it, but how do incorporate into my code or database?

    If anyone's got any idea's please help!



    Public Function formatAddress(v1, v2, v3, v4, v5, v6, v7)
    Dim output As String
    Dim addressArray(7) As String
    Dim i As Integer
    addressArray(1) = v1 & ""
    addressArray(2) = v2 & ""
    addressArray(3) = v3 & ""
    addressArray(4) = v4 & ""
    addressArray(5) = v5 & ""
    addressArray(6) = v6 & ""
    addressArray(7) = v7 & ""
    i = 1
    For i = 1 To 7
    If (addressArray(i) = "") = False Then
    output = output & addressArray(i) & vbCrLf
    End If
    Next
    formatAddress = output
    End Function

  2. #2
    alansidman's Avatar
    alansidman is offline Life @ 7100'
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,457
    Would it be easier to take the address and open Google Translate and put it there and get the English equivalent and then put that in your db? Is this a one-off situation or will it be a case where you will be having lots of orders with Greek addresses that need to be resolved?

  3. #3
    Potatohead is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2013
    Posts
    4
    Quote Originally Posted by alansidman View Post
    Would it be easier to take the address and open Google Translate and put it there and get the English equivalent and then put that in your db? Is this a one-off situation or will it be a case where you will be having lots of orders with Greek addresses that need to be resolved?
    I don't know if the Cypriot postal staff will be able to read English or if it would translate properly, for instance the streets could be named after people and the meaning would be lost or it might cause the package to be delayed.

    I've managed fix this one by cutting and pasting but really I need a proper solution as I will probably be getting more like this from other countries that don't use the English alphabet.

  4. #4
    Potatohead is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2013
    Posts
    4
    I know what's wrong with it now. VB converts unicode text into ansi and in the process loses the non ansi characters.

    Going to ask on the programming forum instead.

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

Similar Threads

  1. Multiple language interfaces
    By cavancura in forum Database Design
    Replies: 3
    Last Post: 12-08-2011, 01:36 PM
  2. changing system language via VBA
    By focosi in forum Access
    Replies: 3
    Last Post: 09-25-2011, 10:40 AM
  3. Language in Access
    By Bill Casanova in forum Access
    Replies: 3
    Last Post: 05-23-2011, 02:00 PM
  4. Programming Language like Access
    By cwf in forum Programming
    Replies: 2
    Last Post: 05-17-2008, 03:02 AM
  5. can't find language DLL
    By tequila in forum Access
    Replies: 0
    Last Post: 05-01-2008, 09:31 PM

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 - Senior Forums