I was messing around with SQL Server Profiler recently and thought to myself “this would be a good way to illustrate VBA connection pooling to people”. Many books recommend using connection pooling when building apps that involve more than a trivial amount of SQL database work. Most of those books describe connection pooling and how […]

Those of you who have ever done any serious programming with SQL Server stored procedures will know that they return an integer value to their caller on completion. The default value is ‘0’, which indicates success, and any other value indicates a failure at some stage in its processing. VBA has the power to capture […]

Polymorphism – the ability to assume more than one form. Q: When can a Cat also be a Dog? A: When it’s a polymorphic Fish. In a Standard Module define this procedure: Public Sub DemoPolymorphism() Dim Pussy As Cat: Set Pussy = New Fish Dim Growler As Dog: Set Growler = New Fish Dim Billy As […]

In C# classes can be given the access modifier “static”. A static class cannot be instantiated and it cannot be inherited. To call a method of a static class you simply specify className.methodName(any parameters of the method) Does this look familiar? In VBA, Modules are static classes. However, there is another way, a way which […]

In .NET, a Delegate is a reference type. A reference type points to something – typically an object. A Delegate, however, points to a method. In VB.NET methods are either Functions or Sub procedures. In C#.NET methods are methods – they either return a value or they don’t (ie. return value type is “void”). I’ll […]