Modules: TSI Xpression 9.0

WARNING: THE PROGRAMMATIC FUNCTIONALITY DESCRIBED HEREIN IS COMPLETELY UNSUPPORTED BY MICROSOFT AND IT IS DOUBTFUL THAT IT WILL BE SUPPORTED IN FUTURE VERSIONS. IT IS VAGUELY POSSIBLE THAT THIS ADD-IN MIGHT WORK IN FUTURE VERSIONS, BUT DO NOT BET HEAVILY ON IT. PLEASE DO NOT BASE AN APPLICATION ON THIS FEATURE UNLESS YOU PLAN TO STAY IN ACCESS 2000 INDEFINITELY. YOU HAVE BEEN WARNED!!!!

To run this add-in, you must register it using regsvr32.exe.

The VB6 runtime files must be on your machine; if they are not, you can get them from here.

TSI Xpression 9.0

To use in the UI

Once you have installed and registered the add-in as above, simply right-click on code in a module in the VBE and you will get the expression builder!

To use programmatically

This ComAddIn written in VB6 can actually be called if you want to use the
Access 2000 Expression Builder from your own code. Install the add-in as 
above, and then you can call it with the following syntax:

Dim st As String
st = Application.COMAddIns( _
            "TsiXpression.Connect").Object.CallExpressionBuilder( _
            ["Expression In"], [AcObjectType], ["ObjectName"])

1. Expression In = optional; the text you want to show up in the expression builder
2. ObjectType = optional; an AcObjectType constant such as acForm or acTable
3. ObjectName = optional; an object of type ObjectType

If you pass an ObjectType and/or an ObjectName that is invalid, then they will be ignored. acModule is not considered a valid type. This is a limitation of the Access Expression Builder.

The return value will be the return from the Expression Builder. It does NOT distinguish between the user clicking "Cancel" and the user clearing out the data; in both cases the return string will be a ZLS (this is a TSI Xpression architectural limitation that will not be addressed, sorry!).

Enjoy the TSI Xpression 9.0 Add-In!

Michael Kaplan
Trigeminal Software, Inc.
http://www.trigeminal.com