Module function in VB6 application

J

Jan Karchnak

Hi,

I have function Function1 defined in MS Access 97 module.
This function is used in query Query1: SELECT A,B,Function1(A) FROM ...
So far so good .. good results.

Now I want to use Query1 in my VB6 application:
Dim rs as recordset
Set rs = Database.OpenRecordset("Query1")
Oops!
Run-time error '3085'
Undefined function 'Function1' in expression.

Help me please!

Thanks
Jan
 
B

Brendan Reynolds

Sorry, Jan, it can't be done. The ability to call custom VBA functions from
queries is a feature of Access rather than of the Jet database engine, which
means that it is not available when using the Jet database engine in other
programming environments.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returning Results from Function in a different DB 1
Undefine Function "FunctionName" in expression 8
Concatenate Function 7
user defined not defined 2
Undefined function in expression 4
access2000 module function in views and VB6 1
Function or Sub? 9
Create one function for all DAO Recordset connections 27

Top