April, 2013
Truncation of Memo fields
http://allenbrowne.com/ser-63.html In Access tables, Text fields are limited to 255 characters, but Memo fields can handle 64,000 characters (about 8 pages of single-spaced text) – even more programmatically. So why do memo fields sometimes get cut off? Queries Access truncates the memo if you ask it to process the data based on the memo: aggregating, de-duplicating, formatting, and so on. Here […]
Exchange Mail Size from Exchange PowerShell
Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label=”TotalItemSize(KB)”;expression={$_.TotalItemSize.Value.ToKB()}},ItemCount Get-MailboxStatistics -Database “Mailbox Database” | Select DisplayName, ItemCount, TotalItemSize | Export-CSV c:\test.csv
Our InfoAge Video Conference Solution
We use join.me 1. Go to http://www.anymeeting.com/ and login 2. Ask the other parties to open their browser and go to www.infoage.co.nz/contact (and click Join Meeting on right hand side) Account details are in KeePass. We can video conference and share screens, Sharing window doesn’t work but sharing a screen 1 or 2 does
Video Conference online solutions
Mikogo Mikogo used to make it WAY more obvious that it was free to use for private individuals. As far as I can tell, it’s still free, to use most features. You’ll have to do a little exploring to see if you can get what you need without paying. On an annual plan, prices start […]
Access Rich-Text: Which subset of HTML is supported?
http://office.microsoft.com/en-us/access-help/insert-or-add-a-rich-text-field-HA010014097.aspx
PHP Tutorials
1. Creating ZIP file with PHP http://www.9lessons.info/2012/06/creating-zip-file-with-php.html 2.
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++) { […]