Tricks
JS Tricks
1. Convert date format in JS from = $(“#datepicker”).val().split(“-“); f = new Date(from[2], from[1] – 1, from[0]); 2. How to count the total number of checked check box var inputElems = document.itemsForm.elements[‘selBox[]’] count = 0; for (var i=0; i<inputElems.length; i++) { […]
Access VBA trick
1. How to ‘hide’ 0 as the chart label, format the label as custom $#,##0_);($#,##0);
Failures caused by Name AutoCorrect
This feature was introduced in Access 2000. It tries to help users who rename a table field, so that queries, forms and reports automatically recognise the new field name. Microsoft has addressed some of the problems with this feature, but is it still buggy, incomplete, and a performance problem. One of the known performance problem […]