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 →

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 →

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 →

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 →

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 →