access2000 module function in views and VB6

[Tarun Ralhan]

Hi everybody,

I have created some functions in access modules. When I
use these functions in my queries, they work fine. But
when I try to use these queries through my VB6 program, I
get:
Run-time error '-2147217900 (80040e14)':
Undefined function 'functionname' in expression.
Can anybody explain why it is so and how I can use
functions defined in my access2000 module thru my VB6
program? Thanks in advance.

 

[Marshall Barton]

I have created some functions in access modules. When I
use these functions in my queries, they work fine. But
when I try to use these queries through my VB6 program, I
get:
Run-time error '-2147217900 (80040e14)':
Undefined function 'functionname' in expression.
Can anybody explain why it is so and how I can use
functions defined in my access2000 module thru my VB6
program?

Jet can't interact with Access unless Access is opening the
query. VB does not provide Jet with the necessary interface
to use UDFs.