VBA functions or custom functions cannot be evaluated from outside
Access. This was never a problem for me before, but it is a major
obstacle in my current project. I'd like to do a little research into
the issue and see if I can find an elegant workaround.
>From what I understand, VBA functions work in Access queries becauseDAO uses something in Access called the "expression service". I'd be
grateful if someone could help answer a few questions about the
expression service:
1. What kind of an animal is the expression service? Is it an object
that can be referenced through the Access object model?
2. Is there a way to create an instance of the Access expression
service from outside of Access and hook up that instance to DAO?
3. Do other applications, like VB6 or Excel, have their own versions
of the expression service, and can those be used to support functions
in queries?
-TC