Problem I have this piece of code for running a Stored Procedure, and I was wondering if there is a […]
Is it a bad programming practice to declare variable in a loop?
Problem Locked. This question and its answers are locked because the question is off-topic but has historical significance. It is […]
A more readable InStr: StringContains
Problem Consider the following: If myString = “abc” Or myString = “def” […] Or myString = “xyz” Then In C# […]
Problem In order to implement my own Dictionary<TKey, TValue> in VB6, I’ve implemented a KeyValuePair class, which can accomodate any […]
No more Fizzbuzz. How about Hello World instead?
Problem Write a program that prints the numbers from 1 to 100. But for multiples of three print “Fizz” instead […]
Revisited IsTypeSafe method implementation for “type-safe” List
Problem Following up on List<T> implementation for VB6/VBA, I’d like some thoughts about the revisited IsTypeSafe function, below. The previous […]
Materializing any ADODB Query
Problem Following-up on Creating ADODB Parameters on the fly and pushing the “wrapping” of ADODB a step further, I have […]
Implementation for VB6/VBA
Problem Because I was spoiled with C# and the .NET framework, whenever I have to work with VB6 I feel […]
Shared VB6 *and* VBA extensibility add-in with OnConnect and OnDisconnect handling
Problem Rubberduck works well enough when the VBE is of the VBA variety, but it currently only works when the […]