Category Archives: Programming

SQL Azure to MS Access – Using VBA to Dump Azure Tables into MS Access Tables

The first thing you need to get sorted when moving to SQL Azure is having the ability to get your information out and safe if needs be. When experimenting with MS Azure and for applications that don’t have sensitive information … Continue reading

Posted in All, MS Access, Productivity, Programming, SQL Azure, SQL MS Access, SQL Server, VBA Code MS Access | Comments Off on SQL Azure to MS Access – Using VBA to Dump Azure Tables into MS Access Tables

Linking to SQL Server / Oracle – don’t skip the set key field on linking

After writing Update queries with multiple joins on linked Oracle Databases I was receiving an error on running particular update queries on linked tables that had no Primary Key identified. On linking the tables I had been asked to identify … Continue reading

Posted in All, MS Access, Productivity, Programming | Comments Off on Linking to SQL Server / Oracle – don’t skip the set key field on linking

MS Access VBA Function – Automated Multiple Query Object Creation from previously created table of SQL

This completes the task of taking automatically generated SQL previously placed in a table and writes the SQL therein to Query Objects naming them automatically. This has several advantages to cut and paste – 1) Its Lightning Quick 2) Completely … Continue reading

Posted in All, MS Access, Productivity, Programming, VBA Code MS Access | Comments Off on MS Access VBA Function – Automated Multiple Query Object Creation from previously created table of SQL

AutoHotKey : Navigation between Satellite Applications to improve Work Flow

A while back I wrote a post about how allowing parameters to be passed to URLs is a big benefit in increasing the speed with which you can navigate to individual records in apparently non-connected web applications. But what do … Continue reading

Posted in All, AutoHotKey, Productivity, Programming, VBA Code MS Access | Comments Off on AutoHotKey : Navigation between Satellite Applications to improve Work Flow

The devil is always in the detail – Setting constants to Russian cyrillics in VB

With programming the devil is always in the detail. Just out of curiosity I was thinking about the code that I have posted that randomises information in a database and I was thinking why don’t I try to randomise the … Continue reading

Posted in All, Database Design, Learning, MS Access, Programming, VBA Code MS Access | Comments Off on The devil is always in the detail – Setting constants to Russian cyrillics in VB

MS Access SQL for randomising the results from a query

I was wanting to randomize the source of a form so that I could test myself on some Russian within a table. Turns out its very simple. Basing a Query on the following SQL will achieve it. SELECT TableName.PKID, TableName.Field1, … Continue reading

Posted in All, Database Design, MS Access, Programming, SQL MS Access | Comments Off on MS Access SQL for randomising the results from a query

Internal Development Good or Bad

Elite Dangerous from Frontier Developments an example of a game built on internally developed game engine – and they are seriously kicking ass as a result. It is tempting having been burnt with IT projects to say right that’s it … Continue reading

Posted in All, General Opinion, Productivity, Programming, The future of software | Comments Off on Internal Development Good or Bad

Complex Event Processing (How Cool)

As part of my timing software solution I had been interested in seeing if there was a better solution to the constant pulling of information from the timing boxes. It would for instance be far better to have some sort … Continue reading

Posted in All, Problem Solving, Programming, SQL Server, The future of software | Comments Off on Complex Event Processing (How Cool)

Step through forms and alter properties.

A nice patch of code that will allow you to cycle through a series of forms and make them read only. Useful if you don’t have immediate access to make changes to the backend, SQL Server or active directory. If … Continue reading

Posted in All, MS Access, Programming, VBA Code MS Access | Comments Off on Step through forms and alter properties.

Configuration vs Programming

I used to find configuration kind of frustrating – highly repetitive unintuitive and often changing as software versions change. I now consider it a simple exercise in rote learning for which there is no solution except perseverance, patience and determination and … Continue reading

Posted in All, Configuration, Problem Solving, Productivity, Programming | Tagged , | Comments Off on Configuration vs Programming