Monthly Archives: August 2014

40 Useful Facts to Know about a System

A list of points I should remember to ask when doing ongoing system development, total re-design or external purchase. For alternative systems rank both existing and new and compare. Collection of facts is as objective as I could make it … Continue reading

Posted in All, Configuration, Database Design, General Opinion, Software Purchase | Comments Off on 40 Useful Facts to Know about a System

VBA access code – Passing a selection of e-mail addresses to Outlook

This is similar to the previous post except uses the inbuilt SendObject object to pass the string sBcc directly to Outlook. Outlook picks up the variables and so there is no need to set up public variables. CODE Private Sub … Continue reading

Posted in All, Database Design, E-mail, MS Access, VBA Code MS Access | Comments Off on VBA access code – Passing a selection of e-mail addresses to Outlook

VBA access code for pulling together a list of e-mails and passing to a form

Below some standard code that I use to loop through a selection of records and create a string from the individual [Email] s in the below case the e-mails are passed to a form (FORMTOOPEN) – if you are using … Continue reading

Posted in All, Database Design, MS Access, VBA Code MS Access | Comments Off on VBA access code for pulling together a list of e-mails and passing to a form

Connecting to SQL Server – authentication and QGIS

Within QGIS when you set up a connection to a MS SQL Server instance you are presented with two options. Here’s a bit of clarification on what the two options entail. * Trusted connection – this is the same thing … Continue reading

Posted in All, Configuration, QGIS General, SQL Server | Comments Off on Connecting to SQL Server – authentication and QGIS

The Importance of a Booking Confirmation and Careful Communication

With booking systems there are a lot of important things that will make a system successful – good operational speed – a well designed table structure – great UI and good stability but without really really great communication and confirmation … Continue reading

Posted in All, Database Design, General Opinion, User Interface Design | Comments Off on The Importance of a Booking Confirmation and Careful Communication

The Gunslinger and the Indian

There’s a fight on your computer over a girl called Planned Obsolecence I get that you need to update software periodically and I definitely want to see software developers paid an appropriate amount but what happens when no one can … Continue reading

Posted in All, General Opinion, Open Source, The future of software | Comments Off on The Gunslinger and the Indian

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