Visual Basic provides more than 200 built-in statements and functions. Some are used frequently; some are seldom used at all. Even experienced programmers sometimes happen upon a statement or function ...

Notifications You must be signed in to change notification settings Inspired by functions avaliable in other BI tools, this is some lightweight function snippets to put into SQL Server Reporting ...

Okay, basic situation:<BR><BR>I have a VB COM DLL that interfaces with a C library to run some functionality that for various reasons can't be rewritten in VB (or even COM). About halfway through this ...

Some of you may be aware that a few VBA functions have been implemented as native MDX functions to improve performance. I blogged about this a few years ago, but I’ve now received an up-to-date list ...

How to use the Round() function? The Round() function consists of two parts: the numeric expression you want to round and the number of decimal places. Below we show an example of an incorrect ...

Sometimes you do and sometimes you don't.<BR>For example the ADODB connection object has the methods open and execute. For open, you pass the arguments w/o parenthesis and for execute you pass with ...