Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Mon Aug 30 16:29:15 CDT 2004
Muchas Gracias.
Sr. Smolín (<-- see?. I can do it now!)
----- Original Message -----
From: "MartyConnelly" <martyconnelly at shaw.ca>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Monday, August 30, 2004 10:41 AM
Subject: Re: [AccessD] Accent Marks Needed
> I see Michael Kaplan has shifted to the dark side again and is now
> working full time for Microsoft in International Development ;)
> Some other things you may run into.
>
> Unicode and Keyboards on Windows (Article)
> http://www.microsoft.com/globaldev/handson/dev/inputinwin.mspx
> Win XP keyboard layouts (Displays layouts on screen)
> http://www.microsoft.com/globaldev/reference/keyboards.aspx
> Old list of regional settings
> http://support.microsoft.com/default.aspx?scid=kb;en-us;193080
>
> Some of this changes in newer versions of OS and Office
> For example WinXP SP2 now supports Welsh unicode keyboard. Hooray.
>
>
> However Spanish has a lot of layouts and may have increased with xp sp2
> This is integer you may want to convert to hex for api calls
> Spanish (Traditional Sort) 1034
> *!* Spanish (Mexican) 2058
> *!* Spanish (Modern Sort) 3082
> *!* Spanish (Guatemala) 4106
> *!* Spanish (Costa Rica) 5130
> *!* Spanish (Panama) 6154
> *!* Spanish (Dominican Republic) 7178
> *!* Spanish (Venezuela) 8202
> *!* Spanish (Colombia) 9226
> *!* Spanish (Peru) 10250
> *!* Spanish (Argentina) 11274
> *!* Spanish (Ecuador) 12298
> *!* Spanish (Chile) 13322
> *!* Spanish (Uruguay) 14346
> *!* Spanish (Paraguay) 15370
> *!* Spanish (Bolivia) 16394
> *!* Spanish (El Salvador) 17418
> *!* Spanish (Honduras) 18442
> *!* Spanish (Nicaragua) 19466
> *!* Spanish (Puerto Rico) 20490
>
> Microsoft Office 2003 Language Settings
> Setting up your Office program to work in more than one language
>
> To work with different languages in your Office program, you need to
> enable the appropriate languages for editing by using the Microsoft
> Office Language
> Settings tool. (On the Start menu, point to Programs, point to Microsoft
> Office Tools, and then click Microsoft Office 2003 Language Settings.)
> Doing so makes
> additional language-specific options available. For example, if you
> install the English (U.S.) version of Office and you enable editing for
> Japanese, commands
> for formatting Japanese text appear on the Format menu in Microsoft
> Word, Microsoft PowerPoint, and Microsoft Excel.
> Using the Microsoft Office Language Settings tool, you can also change
> your default settings in Office to have them match the default settings
> of a different
> language. For example, if you are using an English version of Office but
> frequently work with right-to-left text, you can change the default
> installation language to
> a right-to-left language, thereby setting all of the Office defaults to
> right-to-left.
>
> As you work in Word and PowerPoint, you can set the language of the text
> so that the correct proofing tools are used, and you can add
> language-specific words
> to a custom dictionary. In Word, you can fine-tune the ways the program
> handles text in different languages. For example, you can turn automatic
> language
> detection on or off, sort lists and tables according to the rules of the
> language you choose, and summarize documents in the language you choose.
> Additional
> proofing functionality is available in Microsoft Office 2003 Proofing
> Tools. For more information about Proofing Tools, see the Microsoft
> Office Online Web site.
> If your organization has purchased Microsoft Office 2003 Multilingual
> User Interface Pack, you can also change the language of the user
> interface and Help.
> You can get so-called MUI - Multi User Interface. You can install it on
> top of existing operating system and have a full support for your language
> (including menus, dialog boxes, help, spell-checking etc.)
> 3) Get the multi-language version of OS. This one natively supports
> different localized editions of OS.
>
> Ah you want the MUI MultiLingual User Interface for the OS and Office
>
> http://www.microsoft.com/office/editions/prodinfo/language/default.mspx
> http://www.microsoft.com/globaldev/DrIntl/faqs/MUIFaq.mspx
> http://www.microsoft.com/office/ork/2003/four/default.htm
>
> A lot of this is covered in the ORK Office Resource Kit.
>
>
> Rocky Smolin - Beach Access Software wrote:
>
> >Marty:
> >
> >Thanks for those. It's really for Spanish, and maybe in the future
> >sometime, French. Hopefully I'll never have to learn how to input
Chinese.
> >
> >Rocky
> >
> >----- Original Message -----
> >From: "MartyConnelly" <martyconnelly at shaw.ca>
> >To: "Access Developers discussion and problem solving"
> ><accessd at databaseadvisors.com>
> >Sent: Thursday, August 26, 2004 12:08 PM
> >Subject: Re: [AccessD] Accent Marks Needed
> >
> >
> >
> >
> >>If you are going to get deeper into this.
> >>Here are two rough code snippets to switch languages on the fly for data
> >>entry in Access.
> >>One uses API calls, the other keyboard events.
> >>
> >>The Canadian Government sometimes specifies bilingual French-English
> >>form data entry.
> >>I dunno how to handle DBCS languages like Chinese Big 5. As they say,
> >>that is left for an exercise for the student.
> >>You probably fiddle around with the IME.
> >>
> >>
> >>Public Declare Function LoadKeyboardLayout Lib "user32" Alias _
> >>"LoadKeyboardLayoutA" (ByVal pwszKLID As String, ByVal Flags As Long) As
> >>Long
> >>
> >>Private Declare Function ActivateKeyboardLayout Lib "user32" (ByVal HKL
> >>As Long, _
> >>ByVal Flags As Long) As Long
> >>
> >>Private Declare Function GetKeyboardLayoutName Lib "user32" Alias _
> >>"GetKeyboardLayoutNameA" (ByVal pwszKLID As String) As Long
> >>
> >>Const KL_NAMELENGTH = 9
> >>
> >>Sub testarabic()
> >>Dim lRet As Long
> >>'your language selection bar will have languages added if available on
> >>the machine.
> >> ' warning if bar isn't visible on screen taskbar or floating version,
> >>you may have to go to control panel to reset
> >>' to proper language desired.
> >> lRet = LoadKeyboardLayout("00000409", 1) ' For English
> >> Debug.Print lRet
> >> lRet = ActivateKeyboardLayout("00000409", 0)
> >> Debug.Print lRet
> >> lRet = LoadKeyboardLayout("00000401", 1) ' For Arabic
> >> Debug.Print lRet
> >> lRet = ActivateKeyboardLayout("00000401", 0)
> >> Debug.Print lRet
> >> lRet = LoadKeyboardLayout("00011009", 1) ' For FrenchCanadian
> >> Debug.Print lRet
> >> lRet = ActivateKeyboardLayout("00011009", 0)
> >> Debug.Print lRet
> >>End Sub
> >>
> >>Sub resetenglish()
> >>Dim lRet As Long
> >> lRet = LoadKeyboardLayout("00000409", 1) ' For US English
> >> Debug.Print lRet
> >> lRet = ActivateKeyboardLayout("00000409", 0)
> >> Debug.Print lRet
> >>End Sub
> >>
> >>Sub whatiskeybd()
> >> Dim strName As String
> >> 'Create a buffer
> >> strName = String(KL_NAMELENGTH, 0)
> >> 'Get the keyboard layout name
> >> GetKeyboardLayoutName strName
> >> Debug.Print "Keyboard layout name: " & strName
> >>End Sub
> >>
> >>-------------------------------------------------------------------
> >>
> >>Alternate method for bilingual entry on textboxes
> >>assumes you have only two languages on language bar
> >>or you are using only one hot key switch
> >>
>
>>'http://www.microsoft.com/globaldev/handson/dev/Unicode-KbdsonWindows.pdf
> >>'http://www.microsoft.com/globaldev/nlsweb/default.asp?submitted=40d
> >>
> >>'Part of the file Win32api.txt:
> >>'
> >>' VK_L VK_R - left and right Alt, Ctrl and Shift virtual keys.
> >>' Used only as parameters to GetAsyncKeyState() and GetKeyState().
> >>' No other API or message will distinguish left and right keys in this
> >>'way.
> >>' /
> >>Public Const VK_LSHIFT = &HA0
> >>Public Const VK_RSHIFT = &HA1
> >>Public Const VK_LCONTROL = &HA2
> >>Public Const VK_RCONTROL = &HA3
> >>Public Const VK_LMENU = &HA4
> >>Public Const VK_RMENU = &HA5
> >>
> >>'What a weird name for the Alt-key. but it does use the menu
> >>
> >>Private Const VK_LWIN = &H5B 'Left window button
> >>Private Const VK_RETURN = &HD 'ENTER key
> >>Private Const VK_SHIFT = &H10 'SHIFT key
> >>Private Const VK_CONTROL = &H11 'CTRL key
> >>Private Const VK_MENU = &H12 'ALT key
> >>Private Const VK_PAUSE = &H13 'PAUSE key
> >>Private Const VK_CAPITAL = &H14 'CAPS LOCK key
> >>Private Const VK_SNAPSHOT = &H2C 'Print Screen
> >>Private Const VK_APPS = &H5D
> >> 'Applications key on a Microsoft Natural Keyboard
> >>'from http://support.microsoft.com/view/dev.asp?kb=242971
> >>
> >>Const GW_HWNDFIRST = 0
> >>Const GW_HWNDNEXT = 2
> >>Private Const KEYEVENTF_KEYUP = &H2
> >>
> >>Private Declare Sub keybd_event Lib "user32" (ByVal bVk As Byte, _
> >> ByVal bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As
Long)
> >>
> >>Sub ShiftToLanguage()
> >>'use the following code inside form or focused window or textbox
> >>'to simulate the Alt RightShift = key combination:
> >>
> >> ' then press and then release the AltRight RightShift key
> >> 'order of pressing important
> >> keybd_event VK_RSHIFT, 0, 0, 0
> >> keybd_event VK_RMENU, 0, 0, 0
> >>
> >>
> >> keybd_event VK_RMENU, 0, KEYEVENTF_KEYUP, 0
> >>'weird things happen if you don't up the shiftkey looks like capslock
> >>'has been left on
> >> keybd_event VK_RSHIFT, 0, KEYEVENTF_KEYUP, 0
> >> Debug.Print "Shift"
> >> DoEvents
> >>
> >>End Sub
> >>
> >>Sub ShiftToLanguageBack()
> >>'use the following code inside form or focused window or textbox
> >>'to simulate the Alt RightShift = key combination:
> >>
> >> ' then press and then release the AltRight RightShift key
> >> 'order of pressing important
> >> keybd_event VK_LSHIFT, 0, 0, 0
> >> keybd_event VK_LMENU, 0, 0, 0
> >>
> >>
> >> keybd_event VK_LMENU, 0, KEYEVENTF_KEYUP, 0
> >>'weird things happen if you don't up the shiftkey looks like capslock
> >>'has been left on
> >> keybd_event VK_LSHIFT, 0, KEYEVENTF_KEYUP, 0
> >> Debug.Print "Shift Back"
> >> DoEvents
> >>
> >>End Sub
> >>
> >>Rocky Smolin - Beach Access Software wrote:
> >>
> >>
> >>
> >>>Marty:
> >>>
> >>>Don't know exactly how I did it, but I got the alternate keyboard. AND
I
> >>>can key the accent marks directly in an Access table now.
> >>>
> >>>Thanks to all
> >>>
> >>>Best,
> >>>
> >>>Rocky Smolin
> >>>Beach Access Software
> >>>http://www.e-z-mrp.com
> >>>
> >>>----- Original Message -----
> >>>From: "MartyConnelly" <martyconnelly at shaw.ca>
> >>>To: "Access Developers discussion and problem solving"
> >>><accessd at databaseadvisors.com>
> >>>Sent: Wednesday, August 25, 2004 12:07 AM
> >>>Subject: Re: [AccessD] Accent Marks Needed
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>>Another Method
> >>>>
> >>>>Win XP Control Panel --> Regional Language Settings--> Languages
> >>>>--Details --> Installed services
> >>>>Add the Spanish Keyboard in addition to English.
> >>>>
> >>>>Other button option selections
> >>>>
> >>>>Language -choose to float Keyboard Language Bar on Screen as
transparent
> >>>>or in tasktray
> >>>>I prefer floating bar rather cluttering TaskTray icon
> >>>>
> >>>>Key Settings choose a hotkey to switch language keyboard.
> >>>>
> >>>>This will give you a floating keyboard selection bar
> >>>>
> >>>>Defualt To change language keyboards when typing toggle ALT - Right
> >>>>
> >>>>
> >Shift
> >
> >
> >>>>You can also do this by VBA code. I have used to sense Keyboard
> >>>>language state and switch between French or English Text boxes on same
> >>>>
> >>>>
> >>>>
> >>>>
> >>>form
> >>>
> >>>
> >>>
> >>>
> >>>>There are probably pictures of spanish keyboard mappings at
> >>>>http://www.microsoft.com/globaldev
> >>>>
> >>>>Rocky Smolin - Beach Access Software wrote:
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>Stuart:
> >>>>>
> >>>>>
> >>>>>Thanks. Works well in Word. But it doesn't seem to work the same
when
> >>>>>keying into a table. Any ideas there? It's the language tables in
the
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>mdb
> >>>
> >>>
> >>>
> >>>
> >>>>>where I have to key all this Spanish.
> >>>>>
> >>>>>Rocky
> >>>>>
> >>>>>
> >>>>>----- Original Message -----
> >>>>>From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
> >>>>>To: "Access Developers discussion and problem solving"
> >>>>><accessd at databaseadvisors.com>
> >>>>>Sent: Tuesday, August 24, 2004 2:42 PM
> >>>>>Subject: Re: [AccessD] Accent Marks Needed
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>>On 24 Aug 2004 at 13:34, Rocky Smolin - Beach Access Software wrote:
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>I want to do the Spanish translation of my system, but I'm having a
> >>>>>>>terrible time trying to figure out how to get the accent marks on
the
> >>>>>>>vowels.
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>Simplest solution I've found is to create text in Word and then cut
> >>>>>>
> >>>>>>
> >and
> >
> >
> >>>>>>paste.
> >>>>>>
> >>>>>>>From the Word Help:
> >>>>>>To insert Press
> >>>>>>à, è, ì, ò, ù
> >>>>>>À, È, Ì, Ò, Ù CTRL+` (ACCENT GRAVE), the letter
> >>>>>>
> >>>>>>á, é, í, ó, ú, ý
> >>>>>>Á, É, Í, Ó, Ú, Ý CTRL+' (APOSTROPHE), the letter
> >>>>>>
> >>>>>>â, ê, î, ô, û
> >>>>>>Â, Ê, Î, Ô, Û CTRL+SHIFT+^ (CARET), the letter
> >>>>>>
> >>>>>>ã, ñ, õ
> >>>>>>Ã, Ñ, Õ CTRL+SHIFT+~ (TILDE), the letter
> >>>>>>ä, ë, ï, ö, ü, ÿ
> >>>>>>
> >>>>>>Ä, Ë, Ï, Ö, Ü, Y CTRL+SHIFT+: (COLON), the letter
> >>>>>>
> >>>>>>å, Å CTRL+SHIFT+@, a or A
> >>>>>>
> >>>>>>æ, Æ CTRL+SHIFT+&, a or A
> >>>>>>
> >>>>>>o, O CTRL+SHIFT+&, o or O
> >>>>>>
> >>>>>>ç, Ç CTRL+, (COMMA), c or C
> >>>>>>
> >>>>>>ð, Ð CTRL+' (APOSTROPHE), d or D
> >>>>>>
> >>>>>>ø, Ø CTRL+/, o or O
> >>>>>>
> >>>>>>¿ ALT+CTRL+SHIFT+?
> >>>>>>
> >>>>>>¡ ALT+CTRL+SHIFT+!
> >>>>>>--
> >>>>>>Stuart
> >>>>>>
> >>>>>>
> >>>>>>--
> >>>>>>_______________________________________________
> >>>>>>AccessD mailing list
> >>>>>>AccessD at databaseadvisors.com
> >>>>>>http://databaseadvisors.com/mailman/listinfo/accessd
> >>>>>>Website: http://www.databaseadvisors.com
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>--
> >>>>Marty Connelly
> >>>>Victoria, B.C.
> >>>>Canada
> >>>>
> >>>>
> >>>>
> >>>>--
> >>>>_______________________________________________
> >>>>AccessD mailing list
> >>>>AccessD at databaseadvisors.com
> >>>>http://databaseadvisors.com/mailman/listinfo/accessd
> >>>>Website: http://www.databaseadvisors.com
> >>>>
> >>>>
> >>>>
> >>>>
> >>>
> >>>
> >>>
> >>--
> >>Marty Connelly
> >>Victoria, B.C.
> >>Canada
> >>
> >>
> >>
> >>--
> >>_______________________________________________
> >>AccessD mailing list
> >>AccessD at databaseadvisors.com
> >>http://databaseadvisors.com/mailman/listinfo/accessd
> >>Website: http://www.databaseadvisors.com
> >>
> >>
> >
> >
> >
>
> --
> Marty Connelly
> Victoria, B.C.
> Canada
>
>
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com