function error in query (unknown function name)

[Guest]

I use a function in a query to get a date as a parameter. The query works
fine in all the access 2003 clients at a location except one user. That
users machine returns error 3072, unknown function name when the query in
run. That users access references are the same as the other users (VB for
apps, access 11.0 object library, dao 3.6 object library, ole automation, and
VB for apps extensibility 5.3). As a test I replaced the function in the
query with a hardcoded date and then it works fine.

Is there something else I should be checking or should Access 2003 be
reinstalled on that machine?
Thank you for any thoughts on this error.

 

[Guest]

You forgot to mention what the function was that gave the problem.

 

[Guest]

Sorry about leaving out the function info.

Function GetgdtmFromDate()
' gdtmFromDate is a global date
GetgdtmFromDate = gdtmFromDate
End Function

The criteria in the query is:
Between GetgdtmFromDate() And GetgdtmToDate()

 

[Guest]

I am not the one to help you with this but it looks odd that you have () at
the end in two places but not in the third.

 

[Guest]

The function itself is correct and the query that uses it as criteria returns
the correct info for all of the access 2003 users except one.

 

[John Spencer (MVP)]

I would still suspect that you have a (library) reference problem.

On the computer with the problem, have you tried deselecting a reference and
then adding it back in.

When this happens, you need to take steps to let Access repair the broken
reference(s) ON THE COMPUTER WHERE THE FAILURE IS OCCURING.

Here are MVP Doug Steele's instructions for how to do it:

*** Quote ***

Any time functions that previously worked suddenly don't, the first thing to
suspect is a references problem.

This can be caused by differences in either the location or file version of
certain files between the machine where the application was developed, and where
it's being run (or the file missing completely from the target machine). Such
differences are common when new software is installed.

On the machine(s) where it's not working, open any code module (or open the
Debug Window, using Ctrl-G, provided you haven't selected the "keep debug window
on top" option). Select Tools | References from the menu bar. Examine all of the
selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you just
unselected (you can tell by doing a Compile All Modules), go back in and
reselect them.

If none have "MISSING:", select an additional reference at random, back out of
the dialog, then go back in and unselect the reference you just added. If that
doesn't solve the problem, try to unselect as many of the selected references as
you can (Access may not let you unselect them all), back out of the dialog, then
go back in and reselect the references you just unselected. (NOTE: write down
what the references are before you delete them, because they'll be in a
different order when you go back in)

For far more than you could ever want to know about this problem, check out
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

Just so you know: the problem will occur even if the library that contains the
specific function that's failing doesn't have a problem.

**** End Quote ****

So, follow those instructions and see if your problem goes away.

Check out the following reference
http://www.trigeminal.com/usenet/usenet026.asp?1036