Home  |  About  |   Search   

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

RunCommand Constants

Terms of Use


 

Bugs: Undefined Function in Expression (Error 3985)

Author(s)
Dev Ashish
   If you're using custom or built in functions in queries that are being run from an Addin, you might experience a situation where Access doesn't recognize the functions.

db.Execute "UPDATE tblObjects SET LastUpdated = " _
        & "fGetLastUpdateStamp([ObjectType],[ObjectName]) " _
        & "Where dbID=" & Me.DBId, dbFailOnError

or

db.Execute "qryUpdateTimeStamp"

    Where db=CodeDB()

    Note that this may also happen with built in functions such as NZ.

    I am not aware of a solution to get it to work.  You will have to convert the query to DAO code.


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