Categories
Access DB VBA

VBA MS Access for 32-bits / 64-bits – PtrSafe declaration

The message is clear: The expression On Load you entered as the event property setting produced the following error: The code in this project​ must be updated for use on 64-bit system. Please review and update Declare statements and then mark them with the PtrSafe attribute. So the issue is linked to declare function or…

Categories
Access DB VBA

VBA Converting Khmer Numeric to Ascii for TextBox Number

The error message: The value you entered isn’t valid for this field. For example, you may have entered text in a numeric field or a number that is larger than the FieldSize settings permits. MS Access 2010 Above error is simple for us as our characters are in Unicode and of course, if we check…

Categories
Word

រៀបឯកសារសរសេរខ្មែរផង អង់គ្លេសផង (Prepare Doc for writing both English/Khmer)

នេះជាបញ្ហាធម្មតា និងដំបូងចំពោះអ្នកមិនធ្លាប់សរសេរឯកសារលើកម្មវិធី Microsoft Word ដែលមានខ្មែរផង អង់គ្លេសផង ប្តូរចុះប្តូរឡើងធ្វើអោយទម្រង់អក្សរមិនស្អាត។ Just a quick tip for those who start to write Khmer document which is mostly mixed with English word, it makes you hard to see the doc messup with different font face and not fast enough to write it. But here easy steps or remind you the ways.…

Categories
Spreadsheet

Bypass Excel CSV formula Conversion with Operator signs with Simple Practise

You might try to open a CSV file and got error with some columns with error “#NAME?“, it is because of the excel formula conversion issue when there is an operator sign (+, -) in front of the value of the cell as following example: Some solutions may suggest you to put some few spaces…

Categories
Khmer Unicode Spreadsheet

How to Convert MS Excel document of Limon to Khmer Unicode text

I have already illustrated how we convert a MS Word document from Limon to Uniocde here but I haven’t tried out for case of MS Excel document once. As previously stated, it won’t have a straight way to do it without using some tricking steps. I’ll detail about it later… let me know if it…

Categories
Word

MS Word – Missing Proofing tools – Text in Khmer

You open a document that contain a language other than English such as text in Khmer you got a warning such as: MISSING PROOFING TOOLS This document contains text in Khmer which isn’t being proofed. You may be able to get proofing tools for this language. You might come up with following questions: What is…

Categories
Spreadsheet

ភ្លេច Password របស់ File Excel

​ខ្ញុំមាន File សំខានៗ​ជា​ច្រើន​ដែល​ជា File Excel ក៏ ប៉ុន្តែ​ខ្ញុំ​បានភ្លេច Password ទៅហើយ។ ខ្ញុំប្រើ​ MS Excel 2007. តើត្រូវធ្វើយ៉ាងម៉េចទៅ ដើម្បីបើកបាន?