Solved

Access 97 - built in functions failing

Posted on 2006-11-29
2
165 Views
Last Modified: 2006-11-30
I am working in Access 97.  When use functions like Format() or Str() in a query, I receive the word ERROR in all of the fields.  How do I fix this?
0
Comment
Question by:mgoetz
2 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 18041042
Have you verified that your references are okay? Open your VB Editor and click Tools - References. If you see any which are marked MISSING, note the name, then uncheck the ref and close the dialog. Now reopen the reference dialog and find and re-check the references you noted earlier.

If you do NOT have any references marked MISSING, you may have some corruption. Try a Compact and Repair operation to see if this solves it (note: make a copy of your database first). Finally, if none of those work, try importing all your objects to a new, blank database container.
0
 

Author Comment

by:mgoetz
ID: 18044896
Thank you.  That was the problem.  I really appreciate your quick and accurate response.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

809 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