Monthly Archives: March 2018

MS Access Front End – Linked to PostGreSQL back end – a simple walk through using Access 2003

As I have indicated before MS Access makes a brilliant ETL tool. Important in this is being able to connect to different databases. I have set out how to connect to MySQL and SQLAzure before – the following sets out … Continue reading

Posted in All, MS Access, PostGIS, Postgres | Comments Off on MS Access Front End – Linked to PostGreSQL back end – a simple walk through using Access 2003

MS Access Function Collection that can be used to Generate Housing Forecast Figures

Apologies if you are coming here for the first time. This post is a somewhat dense domain specific holding post for some work I did at the weekend to pull together some thoughts. I was thinking that if I had … Continue reading

Posted in All, MS Access, VBA Code MS Access | Comments Off on MS Access Function Collection that can be used to Generate Housing Forecast Figures

AHK – Useful AutoHotKeyScripts for Outlook specifically

Another set of very useful scripts mainly dealing with creating hotkeys for common Outlook tasks. Note that if you are on a laptop you may have pre-mappings for the function keys in which case you will need to quite possibly … Continue reading

Posted in All, AutoHotKey, E-mail, Personal Development, Productivity | Comments Off on AHK – Useful AutoHotKeyScripts for Outlook specifically

AHK – Useful AutoHotKeyScripts

F2:: ; Close all windows (open/minimized, browsers) but not pwr off WinGet, id, list,,, Program Manager Loop, %id% { this_id := id%A_Index% WinActivate, ahk_id %this_id% WinGetClass, this_class, ahk_id %this_id% WinGetTitle, this_title, ahk_id %this_id% If(This_class != “Shell_traywnd”) && (This_class != “Button”) … Continue reading

Posted in All, AutoHotKey, Chrome, Productivity | Comments Off on AHK – Useful AutoHotKeyScripts

Navigate to Website directly from MS Access using Internet Explorer

One of the major suppliers of planning software to the United Kingdom is a company called Idox Group plc. They produce probably the most popular back office software that runs all aspects of administering planning permission. As such their public … Continue reading

Posted in MS Access, VBA Code MS Access | Comments Off on Navigate to Website directly from MS Access using Internet Explorer

Add Open Street Map to Background QGIS Project and then Digitise against imported Raster

The following is a workflow that can be used to get a raster basemap of anything into QGIS which you then reference to Open Street Map Layers ready for digitising against. This will be useful for approximate digitising of masterplans … Continue reading

Posted in All, QGIS General | Comments Off on Add Open Street Map to Background QGIS Project and then Digitise against imported Raster