-
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: June 2014
Keyser Söze, Code and the World Cup
It seems appropriate given the name of this site and 2014 being a world cup year that I might post something on code that I found a while back now related to establishing fixtures in a league coded by, for … Continue reading
Posted in All, Applied Mathematics, MS Access, VBA Code MS Access
Comments Off on Keyser Söze, Code and the World Cup
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.
Attaching Databases to SQL Server 08R2 Express
It should be noted that the following although the easiest way to get a new database into an instance it should not be used in a production environment. In fact doing so may get you sacked. If experimenting though this … Continue reading
Posted in All, Configuration, Database Design, SQL 08 R2, SQL Server, SSMS
Comments Off on Attaching Databases to SQL Server 08R2 Express
SQL Saturday is coming to Edinburgh
Pretty lucky really some of the worlds most talented DBAs hosting an event about 1km up from my flat. More details can be obtained here. http://www.sqlsaturday.com/281/eventhome.aspx There is a waiting list but might be something for you to think about … Continue reading
Posted in All, Database Design, SQL 08 R2, SQL Server, SSMS, The future of software
Comments Off on SQL Saturday is coming to Edinburgh
Using VBA to open URL in chrome
Haven’t tried this out but could be useful. I have a digital mapping web application that I link to from a database and it has issues with IE but works perfectly in Chrome… shell(“C:\Program Files (x86)\Google\Chrome\Application\chrome.exe -url http:google.ca”) Update : … Continue reading
Posted in All, Database Design, MS Access, VBA Code MS Access
Comments Off on Using VBA to open URL in chrome
Scope of variables – And Getting Confused
Note to self If you are wanting to pass parameter values between forms ensure that you place public variables in a module outside of the form. IMPORTANT – additionally ensure that the same variable names are NOT also listed in … Continue reading
Posted in All, Configuration, Database Design, VBA Code MS Access
Comments Off on Scope of variables – And Getting Confused