by Jonathan Tuppeny | Nov 30, 2021 | Non-technical, Not IT Related
I do panoramic photographs made up hundreds of individual pictures and I was hoping to use the Gigapan Epic to be able to scenes using very small angles between each picture, but I found that the batteries simply didn’t last. As standard, the Gigapan runs on 6...
by Jonathan Tuppeny | Jan 11, 2018 | Non-technical, Not IT Related
For reasons that I won’t go into, I recently had to re-pack an Alesis Strike Pro drum kit back into its box in order to return it. However, this was no easy task due to the fact that the main box is packed full of smaller boxes that fit together like a Chinese...
by Jonathan Tuppeny | Nov 7, 2016 | Technical
One of the problems that often comes up when working with Excel programmatically is that dates are often converted to American date format automatically. So for instance you might open a csv file with the value ’07/11/2016′ in dd/mm/yyyy format only for...
by Jonathan Tuppeny | Apr 11, 2016 | Technical
CSV files are ubiquitous – they are the most common means of transferring data from one system to another using a text file. They do, however, have one major drawback – commas. A string of comma separated values is no problem when all the values are numbers or text...
by Jonathan Tuppeny | Mar 4, 2016 | Non-technical
As the world becomes more mobile and cloud orientated, I have been working hard trying to get a database to run on a smart phone in some form. Ultimately I’d like to host a database in the cloud and then be able to use Access as an interface not only on a desktop PC...
by Jonathan Tuppeny | Nov 11, 2015 | Non-technical
I’ve been developing database solutions using Azure SQL as a cloud-based database for a few years now. The combination of the local functionality afforded by Access coupled with the ability to share data across the internet has proved very powerful. Recently I have...
by Jonathan Tuppeny | Sep 10, 2015 | Technical
One of the great strengths of Access is its ability to act as a front end to other data sources aside from standard Access database files. This gives you the ability to use the user interface resources built in to Access with the database engine strengths of a network...
by Jonathan Tuppeny | Aug 17, 2015 | Non-technical
If I had to come up with a single phrase to describe the myriad of spreadsheets and databases that I’ve encountered over the years it would be – ‘If it looks terrible, chances are that it is.’ I’ve been working with spreadsheets, databases and Visual Basic code...
by Jonathan Tuppeny | Jun 15, 2015 | Technical
When you use VBA as part of an Access database, or if you add in a custom component, you might end up adding a reference to the application. References are links to components or applications installed on your system that are used by the database. For instance, if...
by Jonathan Tuppeny | Jun 15, 2015 | Non-technical
Over the years I’ve been involved in loads of projects and I’ve noticed that there are two key factors that every successful project shares. They seem obvious but it’s surprising how often they’re lacking. At the outset of a project, especially a long and/or complex...
