Okie dokie - I'm guessing you work fo a rather large company. The reason I think that is that most big companies seem to think the few extra MB needed to install Office with all the options would take up too much space on a hard disk that is probably about 40GB.
So there's a chance you might not have all the required classes.
Here's a fairly simple way to check if you've actually got it (and I'll go through step by step)
Open a module, or create a new module.
Type into it this:
now, if you have the cursor in there, and press F5 (the "Run" key), you should get a message box with "a" as the message.
If it doesn't work - you've definitely got a problem.
In Access 2000, the default references ticked (at least, on my computer) are:
[ul][li]Visual Basic For Applications[/li]
[li]Microsoft Access 9.0 Object Library[/li]
[li]Microsoft ActiveX Data Objects 2.1 Library[/li][/ul]
But the main ones needed are the first two.
Once you've got them checked - you should be ok.
To make sure that they work, RIGHT click on the word "Left" in the function you just typed, and choose "Complete Word". If "Left" or "Left$" isn't there, you've still got a problem, which [u]could</u> possibly be the way you're using it in the query, in which case - post your code.
I am a loud man with a very large hat. This means I am in charge