Monthly Archives: November 2017

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