-
Recent Posts
- SQL Azure to MS Access – Using VBA to Dump Azure Tables into MS Access Tables
- MS Access VBA Function (Part 5) – Run SQL Queries from a table
- MS Access VBA Function (Part 4) – Write queries to a table
- MS Access VBA Function (Part 3) Address Matching – Find X Replace Y
- MS Access VBA Functions (Part 2) Address Matching – UK Postcode String Finder
- MS Access VBA Functions (Part 1) Address Matching – Add and Drop Fields
- MS Access – Separate Number from a combined Number Street Field
- MS Access front end – SQL Azure back end Link to Configuration Set UP FMS Group
- MS Access VBA Function – create UID starting at prescribed number
- Linking to SQL Server / Oracle – don’t skip the set key field on linking
- MS Access VBA Function – Loop through Query Objects and write SQL to Table
- MS Access VBA Function – Automated Multiple Query Object Creation from previously created table of SQL
- Chrome v:56.0.2924.87 – Run Web Applications in Application Mode
- MS Access VBA Function – Create MS Access Query Object – more automation :)
- Compact Database automatically using this MS Access Function and VB Script
- MS Access VBA Function – Generate Multiple Nested IIF SQL statements into table with parameter to set Number of Nestings
- Generate Nested IIF SQL using VBA code
- Creation of SITE History from Planning Application Polygons using QGIS
- MS Access like development environments for the Web – 3 alternatives
- Upload XLS information to a specific table or new table within an SQL Azure Database
Archives
- July 2017 (1)
- June 2017 (5)
- April 2017 (5)
- March 2017 (6)
- February 2017 (1)
- January 2017 (1)
- December 2016 (2)
- November 2016 (1)
- October 2016 (1)
- July 2016 (1)
- June 2016 (1)
- April 2016 (7)
- March 2016 (2)
- February 2016 (3)
- January 2016 (2)
- December 2015 (3)
- August 2015 (1)
- July 2015 (2)
- June 2015 (4)
- May 2015 (4)
- April 2015 (2)
- March 2015 (4)
- February 2015 (2)
- January 2015 (4)
- December 2014 (2)
- November 2014 (4)
- October 2014 (8)
- September 2014 (3)
- August 2014 (7)
- July 2014 (6)
- June 2014 (7)
- May 2014 (12)
- April 2014 (8)
- March 2014 (2)
- February 2014 (1)
Monthly Archives: February 2016
The Economics of Immortality (part 2) and a real reason for moving platform.
The announcement in December 2014 that Microsoft was releasing a version of Visual Studio Community to virtually everyone for free and then again a further announcement in February 2016 of Microsoft’s purchase of Xamarin and subsequent release with VS community … Continue reading
Posted in All, Dev Ops, General Opinion
Comments Off on The Economics of Immortality (part 2) and a real reason for moving platform.
Using Task Scheduler and Visual Basic Scripts to automate pretty much anything Win 7
This is hardly ground breaking but windows Task Scheduler can be used to run VBS scripts on a variety of events to automate repetitive and boring tasks. Backups for example or refreshing caches on web browsers before users come in. … Continue reading
Posted in All, Backup, Configuration, Dev Ops, VBS Scripts
Comments Off on Using Task Scheduler and Visual Basic Scripts to automate pretty much anything Win 7
Early and Late Binding
Good article on Early and Late Binding MSDN Early and Late binding Coding can appear very complicated sometimes but to simplify the difference in terms of implementation this line is very clear; The only difference between early binding and late … Continue reading
Posted in All, MS Access, VBA Code MS Access, VBA Code MS Excel
Comments Off on Early and Late Binding