NathanFriend.co.uk

Developers notebook

Category: Uncategorized

Fix OS X slow populating file picker

rm ~/Library/Caches/CloudKit/CloudKitMetadata*;killall cloudd

Orignal source: http://osxdaily.com/2015/04/17/fix-slow-folder-populating-cloudkit-macosx/

Start MySQL on Yosemite

sudo /usr/local/mysql/support-files/mysql.server start

Orignal source: http://osxdaily.com/2014/11/26/start-stop-mysql-commands-mac-os-x/

Duplicate a directory structure.

From the root of structure you want to duplicate run find . -maxdepth 2 -type d | sed 's/$/"/' | sed 's/^/mkdir "/' > create.sh

-maxdepth sets the recursion level.
-type d identifies only directories.
sed commands wrap the output in mkdir “{Path}”

Output is redirected to a file.

MS Access Sum a date time field

Example data

id TimeElapsed User
1 00:01:44 Bob
2 00:01:46 Bob

To sum a date time field first convert the field data to double with an expression using the CDbl Function.

exp1: CDbl([TimeElapsed])

Set the total type to Sum.

Then create another expression to convert the data from the first expression back to a date time field using the CVDate function.

exp2: CVDate([exp1])

Set the total value to Expression.

TimeElapsed User
00:03:30 Bob

© 2017 NathanFriend.co.uk

Theme by Anders NorenUp ↑