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