Module functions can't be found, but only on one computer

[Pongetti]

Hello,

I have a function that I created as a public function in a module so it
could be used in queries, etc. The database is on a network and is used by
many people each on their own seperate computer. For some reason one
paticular computer can't find any functions in modules.

This one computer can't seem to use modules. It simply can't find any of
the functions that I create. I have tried creating other modules and it
can't find the functions in those either. (I have multiple queries that use
this. One tells me it's too complex to evaluate, others give me a typical
dialog asking for the function's value) The functions and queries that use
them work perfectly fine on every other computer! About 100 people on 100
computers have been using this for a week and I have recieved this complaint
only from the one person.

The computer has the same version of Access as every other machine. I tried
logging into the database with my username and it still didn't work, so it's
not a permission problem. I thought it might be a missing reference but none
of the references said missing when I went to the dialog.

This is a wierd one. Thank you for any suggestions.

 

[Douglas J. Steele]

It could still be a problem with the References collection.

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!)

 

[Pongetti]

Hello, thanks for the reply. Unfortunately, no such luck though. It still
does the same thing.

My functions work if I call them through the immediate window, they just
aren't found when called in queries and macros, etc.

I even tried putting the function in a macro, and finding it using the
expression builder. The function is found in the expression builder but when
I run it I get "The expression you entered has a function name that microsoft
access can't find"