Scope of User Defined Function in Access

G

Guest

I've built a user function in an Access Module and it works fine as called
from a query within the .mdb. My problem is that I'm trying to use Excel as
a reporting front end using an External Data link to the Query in Access and
I get an error while trying to connect - Undefined function 'AllocationRate'
in expression. Here's my function definition:

Option Compare Database
Option Explicit

Public Function AllocationRate(Start_Date As Date, End_Date As Date,
TargetMonthDay1 As Date, DaysInMonth As Double) As Double
....
End Function

Any thoughts??
 

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

user defined not defined 1
Undefined function in expression 4
Help with my function vba code 1
Can I use a user created function in a report? 2
User-Defined Fx in Query not Working 3
how to use a user defined function in Access from ASP 1
Function "Workingdays" query error date 6
User Defined Function 6

Top