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
VBA

Declare and compare a variable with Khmer unicode string in VBA, excel

Khmer unicode character string is different from other unicode character, we can’t write it on VBA editor of Excel or MS Access.