• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

Access 97 - built in functions failing

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
mgoetz
Asked:
mgoetz
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
mgoetzAuthor Commented:
Thank you.  That was the problem.  I really appreciate your quick and accurate response.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now