[AccessD] Queries with vba function inside...

Hi all,


I need your help, if you mind!

I have a select query that uses a vba function in one field.
another one uses an integrated function like formatpercent.

I need to use these queries from within Excel, using an ADODB command
object.

I get an error message saying that both functions, vba and integrated, are
not recognized.
(error 3085 function not defined in the expression)

I'm afraid it's not possible to use this kind of queries like that.

Would you confirm?
Are there any tricks??

I further question:

How would you trigger from Excel, a public function that is in access?

Thank's in advance,

Philippe