?
Solved

Access 97 - built in functions failing

Posted on 2006-11-29
2
Medium Priority
?
170 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
[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
2 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

764 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