Undefined function 'Right' in expression. 2

[kszacki]

I get this kind of message while opening (for ex. design view) query which uses 'Right' function.
It the same with all 'string' functions.

I remember I had this problem with Access97.
But I forgot what should I do.
please help


Charles

 

[kszacki]

Sorry... I forgot to tell... I am using Access 2000.

 

[nmtexman]

What is the message you are getting?
Bob

 

[JoeMiller]

Go into a code window and click tools-->references. Look for an item that is MISSING: and replace it.

HTH Joe Miller
joe.miller@flotech.net

 

[nmtexman]

The References window refers to object libraries available to you. An object file is a file with an .olb extension. There are five objects that need to be referenced (checked) for use with Access. These are Visual Basic for Applications, Microsoft Access 9.0 Object Library, Ole Automation, utility, and Microsoft DAO 3.6 Object Library. If any of these are unchecked, you need to check them. It might be necessary to have your Access 2000 installation CDs available.

 

[kszacki]

Thanks Thanks Thanks
I was waiting 15 minutes for reply !!!

And now all works just fine...

... so I can start (tomorrow) my 11 day holiday (canoe trip)

thank YOU ALL good people

Charles
(POLAND)

 

[nmtexman]

Good luck. Don't turn over your canoe. Our Governer flipped his kayak recently. Big stink.
Bob