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
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( _
["Expression In"], [AcObjectType], ["ObjectName"])
- Expression In = optional; the text you want to show up in the expression builder
- ObjectType = optional; an AcObjectType constant such as acForm or acTable
- 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!
Trigeminal Software, Inc.