Article ID: 105666 - View products that this article applies to.
This article was previously published under Q105666
Moderate: Requires basic macro, coding, and interoperability skills.
The Microsoft Access manuals do not contain a listing of all the error codes and messages you can receive when you are running custom Access Basic functions. To obtain the error codes and messages, you can run a custom Access Basic function and use the Microsoft Access Help system.
This article assumes that you are familiar with Access Basic and with creating Microsoft Access applications using the programming tools provided with Microsoft Access. For more information on Access Basic, please refer to the "Introduction to Programming" manual in Microsoft Access version 1.x, or the "Building Applications" manual, Chapter 3, "Introducing Access Basic" in version 2.0.
There are approximately 700 error messages that can result from running Access Basic code. To print a list of the error values and descriptions to the Immediate window, add the sample function below to a module:
The following example demonstrates how to save the error code list in a table:
The Microsoft Access Help system contains descriptions of the errors. However, the error values are not in the Help system. To determine the error value, match the description to the values returned by the FillErrorTable() function.
For more information about error messages, search for "error messages: reference," and then "Error Messages Reference" using the Microsoft Access Help menu.
Article ID: 105666 - Last Review: May 6, 2003 - Revision: 2.0