It could be an issue with the References collection, Stephen: I seem to
recall that I've run into those a couple of times with some of your
applications.
To the original poster: with any module open, select Tools | References from
the menu. Examine all of the selected references (they'll always be at the
top of the list). If any of the selected references have "MISSING:" in front
of them, unselect them, and back out of the dialog. Since Stephen's unlikely
to have included the reference if you didn't need it, go back into the
dialog, scroll through the list until you find the reference you just
deleted, and reselect it.
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)
Recognize that such problems occur because of version differences between
your machine and the one on which Stephen developed the application. It's
possible that Stephen wrote the application prior to a particular service
pack, and never replaced the version on his site, or that you haven't got
all the service packs on your machine.
What errors are generated when you attempt to call the function?
[quoted text clipped - 15 lines]