Home  |   French  |   About  |   Search  | mvps.org  

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

In Memoriam

Terms of Use


VB Petition

Bugs: Common Functions like CurrentDB, str$, Mid$ fail to work

Author(s)
Terry Kreft

(Q) My Access 97 database runs fine on some pcs, but on one particular machine, I keep getting errors like "Undefined Function" or "Function not available in query expressions". Upon hitting Debug, one of the following functions are highlighted:

Left$, Right$, Mid$, Instr, Trim, Str (etc)

What's causing this error to happen on individual machines?

(A) This is a common problem that users might face whenever they upgrade from Office 95 to Office 97. Sometimes, Access loses references to libraries containing the definitions to above and other functions, giving you the error message.

Open a module go to Tools/references, check the list of references and find the one that is marked missing, you will probably find that the file the reference requires is either not on the machine or not registered (if it is an OCX/DLL/Exe etc) or is in the wrong place (an Access Library database for example).

The important things are:
    1) identify the missing reference
    2) remove it from the references
    3) re-establish the reference if it is required by
        Pointing at the correct file (using) browse)
    or
        Putting the file on the target machine (and register it if required)
    or
        Register it if it is present

You can also download the References Wizard which will help you in sorting out this problem.


1998-2010, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer