If references are messed up -- you can get that Undefined Function message.
Try following these steps (from a post by Douglas Steele, MVP):
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://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

Signature
Ken Snell
<MS ACCESS MVP>
> I have a multi-user Access database that has been running
> well on 3 different workstations. Only now, for some
[quoted text clipped - 24 lines]
>
> What could be missing?
Thank your Mr. Snell. I'll give that a shot. I
appreciate the response.
>-----Original Message-----
>If references are messed up -- you can get that Undefined Function message.
[quoted text clipped - 57 lines]
>
>.
rafmarce - 14 Mar 2006 16:48 GMT
>If references are messed up -- you can get that Undefined Function message.
>
[quoted text clipped - 31 lines]
>>
>> What could be missing?
Great!!!!!!
I experienced the same problem with XP but thank you in a few steps (unselect
a selected reference; back out of the dialog; go back in and select the
reference just unselected) I solved it.
Greetings from Rome, Italy
It is very likely that you have a missing reference on the PC in question.
Open any code module and select Tools|References. If any are missing,
you'll need to correct that condition.

Signature
Michael Badnarik for President '04
Libertarian...the freedom party
www.lp.org
www.badnarik.org
"If you are in prison and your chances are 50% for execution by electric
chair, 45% for execution by lethal injection, and 5% for escape, are you
just going to vote for the chair because it is the likeliest outcome?" Vote
Libertarian and live to be free.
>I have a multi-user Access database that has been running
> well on 3 different workstations. Only now, for some
[quoted text clipped - 24 lines]
>
> What could be missing?
I appreciate that. However, that was the 1st thing I
looked for and none are missing.
>-----Original Message-----
>It is very likely that you have a missing reference on the PC in question.
[quoted text clipped - 31 lines]
>
>.