Windows 10: Change Language Case

On my Windows 10 Pro / Microsoft Surface 6 Pro, I did a setup wrong from the beginning to select UK as my language/keyboard and it’s likes nightmare as I cannot completely remove it, it did remove each time I tried around such as follow this post, or this post, etc. as it may randomly…

How-To Java Reporting

Jasper Report: Print Column Footer only at the last page

Report designer mostly said it’s depended on the way you design the report, of course, it does but for some new or even some years report designers still need example, tips to help too. Here, I take this kind of issue/solution that finally I could make it: “printing a signature footnote to the last table…



In previous version of MySQL (before v8), we can grant/create mysql user one and grant it at once to get access by each host (location / base on your mysql config. In MySQL 8, you no longer can (implicitly) create a user using the GRANT command. You need to do by CREATE USER and…

Java Reporting

Jasper Report: Total Pages

To have total pages, you can do two options: On view using $V{PAGE_NUMER} flexible using evaluation time: current page with “Now”, total page with “Report” Create a variable for total page Name: TOTAL_PAGES (or any other) Variable class: Integer Calculation: highest Reset type: report Increment type: page Variable expression: ${PAGE_NUMBER} Then you can use on…

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…

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…


VueJS – Implement Oganization Chart with Title

I use this Vue Wrapper: OrgChart JS At first, I could not figure out the chart to display: name + title. Finally I got the point! Here how I go… Install npm install vue-orgchart -S And setting up the style per its website. Implementation export default { components: { VoBasic }, data () { return…


[Laravel+DBAL] Doctrine\DBAL\Driver\PDOStatement contains 3 abstract methods

I though before not to share every error I met during the development I did so far but it’s just facing more often with the same issue so let’s make it documents for others. I have a Laravel 5.5.* and use the package: Doctrine\DBAL which is on version v2.5.13, it was working fine, it might…


Welcome to our contributor Sysome HO (Mr.)

As you may notice recently we have some new articles on this blog, mostly related to programming tips and of course, it will be on other topics soon. We have a new volunteer who is passionate on sharing knowledge, as I’m very happy to see his hard working on writing those articles. Let’s welcome him…


រៀបឯកសារសរសេរខ្មែរផង អង់គ្លេសផង (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.…