Some string functions not working

[creativity57]

Wherever i use mid,right,left,format functions it gives me an error "Cannot find the library or Object". What is the solution? Pls someone throw some light on this.

[zmbd]

<alt><F11>
Menu/RibbonBar:Tools:References

In the pop-up dialog box; make sure that that you have at least the following references selected:
(for Acc2010, your versions numbers may be different)

• Visual Basic For Applications
• Microsoft Access 14.0 Object Library
• OLE Automation
• Microsoft Office 14.0 Access database engine Object Library

Because I use a lot of Excel, ADOX, and Explorer I also have the following selected - these are normally optional and allow for early binding:

• Microsoft Internet Controls
• Microsoft Excel 14.0 Object Library
• Microsoft ActiveX Data Objects 6.1 Library

make any other selections for tools you use and select [OK]

Otherwise you are looking at something that damaged your install... the easiest fix is the self repair option in office; however, we'll need to know which version of both Windows (or what operating system) and which version of Office you are using before I can tell you how to reach that tool (or you can use the [F1] key, the help-link within office, or an internet search engine and locate it that way)

[NeoPa]

These functions are to be found in the VBA.Strings class. That is, the "Visual Basic For Applications" library and the "Strings" class within that.

As this library is one of the defaults that should always be included, it would seem that someone has actually deselected it for some reason or, more likely, you have a dodgy install. The former is fixed easily. The latter requires a re-install where you must ensure Access is fully installed with at least the VBA and coding facility selected.