Solved

Function errors in Microsoft Access 2003 (Date, Trim, Function)

Posted on 2011-02-27
3
495 Views
Last Modified: 2013-11-29
I am in the process of migrating to Win 7 from XP. The main issue every time I change to a new OS is getting all my programs to work. The most important item to work 100% is my old Access database. It was originally written in Access 2.0 (Windows 3.11) and has been converted and modified as I changed Access versions over the years. In XP, I am presently using my database with Access 2003 without any glitches. After installing Access 2003 in Win 7 with all its SP's  and updates, a few functions do not work. Both Date=() and Now=() are not recognized, as well as Function and Trim that I use in reports.
0
Comment
Question by:ysc2
3 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 34992041
Open any module in design view.
Choose Tools>References from the menu.
You will have at least one item marked as missing and this needs to be resolved.
Note the description and deselect the item.  Close and re-open the References dialog and now scroll down and find the Missing library and select it.
Close References and use Debug>Compile to check no errors remain.


0
 

Author Comment

by:ysc2
ID: 34992086
Actually I found someone who said to deselect the missing DOA 3.5 object library and select the newer 3.6 library. Works fine. Thanks!
0
 
LVL 31

Accepted Solution

by:
Helen_Feddema earned 125 total points
ID: 35047235
You will also get these misleading error messages referring to perfectly sound functions like Mid and Trim if you open a database in a higher version of Access, then later in a lower version.  This is because some references (Word and Outlook in particular) will upgrade to a higher version, but not downgrade to a lower version.  See my Access Archon #107 for a discussion of this problem.  It is now nine years since I wrote that article, but Microsoft still hasn't fixed the problem.  I just experienced it today with Access 2007 and 2010.  Here is a link for downloading the article:

http://www.helenfeddema.com/Files/accarch107.zip
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now