Category Archives: All

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

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

Links to GIS information for test system design

If you are trying to design software that includes a Geographical element it is easier if you are working with data that makes some kind of sense. The following are a list of sites where you can get good and … Continue reading

Posted in All, Geographical Information Systems, GIS | Comments Off on Links to GIS information for test system design

MS Access 2010 – Simple Function to loop through a list and Print to file an individual PDF

Had to move to MS Access 2010 to do this as no facility for direct to PDF print in MS Access 2003 Where the fields in the QUERY-ListofIDtoPrint includes ID / Field02 / Field03 / Field04 Public Function LoopandPrint() Dim … Continue reading

Posted in All, MS Access, VBA Code MS Access | Comments Off on MS Access 2010 – Simple Function to loop through a list and Print to file an individual PDF

SQL SERVER – Create TSQL Trigger to add date to existing record after INSERT or UPDATE

I came across an interesting issue with a web application I have been trying to create. DEFAULTS in SQL Server didn’t seem to be registering when new records were inserted through the web application. How come? Surely the web application … Continue reading

Posted in All, Database Design, SQL Azure, SQL Server, TSQL scripts | Comments Off on SQL SERVER – Create TSQL Trigger to add date to existing record after INSERT or UPDATE

MS Access – VBA Functions – Create Category Tag Junction Table by comparing a text field against a table of categories

Going forward there are more and more systems that have somewhat un-formated text or memo fields. It can be useful to tag fields. Here’s a collection of 2 functions with a script to pull them together designed to create a … Continue reading

Posted in All, Database Design, VBA Code MS Access | Comments Off on MS Access – VBA Functions – Create Category Tag Junction Table by comparing a text field against a table of categories

MS Access – VBA – Open Form and go to record from unbound List Box

Very clean and simple Private Sub List0_Click() Dim stFormName As String Dim stLinkCriteria As String stFormName = “Form1” stLinkCriteria = “[ID]=” & Me.List0 DoCmd.OpenForm stFormName, , , stLinkCriteria End Sub

Posted in All, Database Design, VBA Code MS Access | Comments Off on MS Access – VBA – Open Form and go to record from unbound List Box

Simple Bat File to open multiple Web Pages in One Browser Window with alternate Tabs

Simple but can be useful Useful if you are wanting to open multiple tabs in a browser window at the same time @echo off start “Simple Search” “https://planning.westlothian.gov.uk/publicaccess/search.do?action=simple&searchType=Application” start “Google Maps ” “https://www.google.co.uk/maps/@55.8625775,-3.6759593,17z” start “WLC Spade” http://gis.westlothian.gov.uk/wml/spade/” start “idoxEDRMS Login” … Continue reading

Posted in All, Configuration, Dev Ops, General Opinion | Comments Off on Simple Bat File to open multiple Web Pages in One Browser Window with alternate Tabs

Pivoting Relationships from Many to Many – One to Many – One to One – and then Key Value – Relationships and Schemas

There are a whole host of applications in which you may wish to record the biological or legal relationships between individuals. Here is a short investigation of some of the subtleties related to the options you have to model this … Continue reading

Posted in All, General Opinion, MS Access, Normalisation | Comments Off on Pivoting Relationships from Many to Many – One to Many – One to One – and then Key Value – Relationships and Schemas

SQL Azure – SQL to Select Distinct list of Child Records based on a Maximum or Minimum Child Field Value

Following on from the previous post I wanted to know the syntax for SQL to do the same but in SQL Azure. SELECT * FROM dbo.T02AttendanceGame T1 WHERE Attendance = ( SELECT max(Attendance) FROM dbo.T02AttendanceGame T2 WHERE T1.FKID=T2.FKID ); I … Continue reading

Posted in All, SQL Azure | Comments Off on SQL Azure – SQL to Select Distinct list of Child Records based on a Maximum or Minimum Child Field Value

MS Access – SQL to Select Distinct list of Child Records based on a Maximum or Minimum Child Field Value

So we have a table of Stadiums and a table of attendances. We would like to create a query that shows an individual child record for each stadium of the highest attendances. Quite often you seek the latest or earliest … Continue reading

Posted in All, MS Access, VBA Code MS Access | Comments Off on MS Access – SQL to Select Distinct list of Child Records based on a Maximum or Minimum Child Field Value

Javascript – Nubuilder Specific to save Date to DateUpdated field on Record Change (not subform)

From the admin screen go to Develop / Forms / Form of choice / Custom Code / Javascript To place focus on the search button function nuLoadBrowse(){ $(‘#nuSearchButton’).focus(); } Function to Get System Date function GetTodayDate() { var tdate = … Continue reading

Posted in All, Javascript, nuBuilderPro | Comments Off on Javascript – Nubuilder Specific to save Date to DateUpdated field on Record Change (not subform)

SQL Azure link to managing permissions

Just a note to myself to go off and study the following link. SQL Azure Permissions

Posted in All, SQL Azure | Comments Off on SQL Azure link to managing permissions

SQL Azure – Take Complete Backup of Azure Database (Structure and Data)

SQL Azure as part of the service offers a number of differing back up options as standard – however you may wish to take additional backups which for instance you can load onto a local version of SQL Server (Express … Continue reading

Posted in All, Backup, Dev Ops, SQL Azure | Comments Off on SQL Azure – Take Complete Backup of Azure Database (Structure and Data)

Connect MS Access 2003 to MySQL

It is an incredible feature of MS Access that it is so easy to connect to different databases and use as a Management Studio. Having a unified platform across all the different backends is very very useful. Setting up those … Continue reading

Posted in All, MS Access, MySQL | Comments Off on Connect MS Access 2003 to MySQL

VBA : Scripting in MS ACCESS to run multiple Queries consecutively

It can be necessary for many reasons to want to run queries consecutively without supervision. This was particularly necessary for me when I was doing a system transfer project. The production Oracle server was being used on a daily basis … Continue reading

Posted in All, MS Access, VBA Code MS Access | Comments Off on VBA : Scripting in MS ACCESS to run multiple Queries consecutively

VBA Code : Run a Function and Link Functions together ( or Scripting in MS Access)

MS Access can be used as an extremely powerful scripting environment that can tie together manipulation of data using VBA functions and SQL. Before you can really use this power however you need to know three things 1.Where to put … Continue reading

Posted in All, VBA Code MS Access | Comments Off on VBA Code : Run a Function and Link Functions together ( or Scripting in MS Access)

Upload Shape Files into SQL Azure using OGR2OGR – Explanation of SQL Azure Connection String to be placed within OGR2OGR Command Line

Lets say you have a SQL Azure Server with the following parameters SQL Azure Instance : azureinstance1 Database name within Instance : TouristDB1 Your User Name is : tom Password is : Edinburgh The SQLAzure connection string would be MSSQL:Server=tcp:azureinstance1.database.windows.net;Database=TouristDB1; … Continue reading

Posted in All, SQL Azure, SQL Server, SSMS | Comments Off on Upload Shape Files into SQL Azure using OGR2OGR – Explanation of SQL Azure Connection String to be placed within OGR2OGR Command Line