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 | 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 | 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...
