Access QueryDefs, Functions and Excel

[ptozer]

hi,

I have a question for everyone:

I have a Query in Access that references a function written in Access' Global module. This works just fine in Access.

I am trying to execute a select statement from Excel that uses the Querydef in Access, as in

Select * from Query1;

When I try to open a record set from this statement, I get a run-time error # '3085' and the message that there is an undefined
function in the expression.

I have no idea what to do about this.

Any help out there?
Thanks!
Pati Tozer

 

[catt]

I hope you already found the answer to your question but if not, is it possible that the module must be written in excell?

Even though, I use Office, I am only familiar with Access coding. But from what I have read, Office mechanics are interchangeable but not 100%. Try pasting the module to Excel.

Hope this works.