Don:
When it gives you that "function is not available..." message, it usually
means that you have a missing reference.
Go to the code window (VBA Integrated Development Environment) and go to
TOOLS > REFERENCES and check to see if any are showing up as MISSING. If so,
uncheck it and if not, then uncheck one of the checked ones anyway and close
everything and reopen. It SHOULD fix the problem.

Signature
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________
> I've been using an Access 2000 (part of Office 2000) database for
> several years now for my stamp collection with no problems; but
[quoted text clipped - 3 lines]
> appreciate any suggestions besides going back to XP.
> Thanks, Don.
Don - 12 Jan 2008 00:36 GMT
On Jan 11, 12:53 pm, boblarson <boblar...@discussions.microsoft.com>
wrote:
> Don:
>
[quoted text clipped - 12 lines]
> If my post was helpful to you, please rate the post.
> __________________________________
Thanks, Bob, your help was right on!
Don