Pat-
When a built-in function like Right starts failing, it usually means there are one or more libraries referenced by your VBA project that can't be found. Open the VB Editor and choose References from the Tools menu. If it's saying it can't find either the Access or VB libraries, that means the install of Office 2013 needs to be repaired. This can sometimes happen on machines that have more than one version of Access installed.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Pat Fallon
Sent: Tuesday, December 03, 2013 3:29 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] MS/Access 2013 creating problems w old simple database
I have fallen off the ranks as a “professional” but I still use the product. I did not deliver any MS/Access as an executable – I delivered the database to be used and modified as desired by the user.
Several built-in functions have been running for years. Recently machine was upgraded to MS/Office 2013. Now any query which builds an expression using a function is failing.
Example:
RallyJumpHt: IIf(Right([class id],1) In ("5","6"),"00",[cjmpht])
Error message is: Undefined function 'Right' in expression
This brings you to an answer from the msdn.microsoft.com site:
Undefined function <name> in expression. (Error 3085)
***
Is there a library that the database should be referencing which was lost when the 2013 was introduced?
pat fallon
mechanicsburg, pa (http://www.pat-larry.com)
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar