Solved

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

Posted on 2011-02-27
3
516 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

623 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