queries not recognizing vba functions

[Charles]

I inherited a database that has some functions written in VBA that are used
in some queries, e.g. a MaxOfList query that should return the maximum value
for a record over a set of fields. When I run it I get an error. The query
doesn't seem to recognize the function although the function is listed in a
module in the database. I believe it used to work for the old user when they
had Access 2000. We now have Access 2007. Does anybody know how I can get
the functions to run in the queries?

Thanks

 

[Arvin Meyer MVP]

You may want to change the macro security level.

 

[Mr. B]

Charles,

The first thing that comes to mind is, Are you sure that the location where
the database file exists is defined as a "trusted source" location? If not,
that can be the problem.

If that is not the problem, the next thing to try is to attempte to compile
the vba code and see if you have any errors.

Beyond that, you will just have to post back with as much detail as possible
and you may need to post the function code.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm