Category Archives: Class Library

The Class Library contains code and demonstration examples of various class modules and their usage.

Instance

clsInstance helps to create and manage form instances. Using Form instances is an alternate technique for opening forms. Using a form instance makes it possible to open a second copy of a form that is already open in Form View so the application can show two records from the same table simultaneously for example.
Continue reading →

HL7 To XML

This is a VBA port of a C# class that takes an HL7 message and converts it to an XML document object and returns the resulting xml as a string.
Continue reading →

Filter Field

clsFilterField helps build filter and where expressions. An object of this class can be used, for example, to create a filter or where condition using the value that a user selects from a combobox .text property (using the combo’s AfterUpdate event, for example.) Regardless of the actual value of the selection, the combo box .Text property is, of course, text. This class takes care of creating the filter or where expression with the correct delimiters for the field to which it will be applied.
Continue reading →

Collection Class

CollectionWrapper Class Summary

This Visual Basic Collection Class is a wrapper for the collection object in VBA and allows for additional functionality than what is offered by using a collection object by itself. As it is setup currently, this class is not strongly typed, meaning that you could add a bunch of strings, numerics, or objects to it. This may be the desired result, or you may choose to modify it to only deal with one specific object or variable type. To do this, change the Add method and Item property from Variant to the variable of object type of your choosing.
Continue reading →

Asynchronous HTTP Request Class

This class is a wrapper (Facade in the language of design patterns) around the XMLHttp class of the Microsoft XML Core Services (MSXML) library. The purpose of the class is to make an asynchronous HTTP request and receive a response from a VB6/VBA based client.
Continue reading →

KeyNavigator

This makes it easy to provide datasheet-like navigation to continuous forms. To enable the this functionality, you only need to add four lines to the continuous form’s module:
Continue reading →