access2000 module function in views and VB6

  • Thread starter Thread starter Tarun Ralhan
  • Start date Start date
T

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.
 
Tarun said:
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?
Click to expand...

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