Access 2002 (XP) Trappable Errors Numbers And Descriptions

Following are a substantial list of trapable errors with their numbers for Access XP.  These numbers will probably apply to Access 97 and 2000.  Search your Access visual basic help for "Trappable Errors"

3 Return without GoSub
5 Invalid procedure call
6 Overflow
An overflow results when you try to make an assignment that exceeds the limitations of the target of the assignment. This error has the following causes and solutions:

The result of an assignment, calculation, or data type conversion is too large to be represented within the range of values allowed for that type of variable.
Assign the value to a variable of a type that can hold a larger range of values.

An assignment to a property exceeds the maximum value the property can accept.
Make sure your assignment fits the range for the property to which it is made.

You attempt to use a number in a calculation, and that number is coerced into an integer, but the result is larger than an integer. For example:
Dim x As Long
x = 2000 * 365 ' Error: Overflow
To work around this situation, type the number, like this:

Dim x As Long
x = CLng(2000) * 365

7 Out of memory
More memory was required than is available, or a 64K segment boundary was encountered. This error has the following causes and solutions:

You have too many applications, documents, or source files open.
Close any unnecessary applications, documents, or source files that are open.

You have a module or procedure that's too large.
Break large modules or procedures into smaller ones. This doesn't save memory, but it can prevent hitting 64K segment boundaries.

You are running Microsoft Windows in standard mode.
Restart Microsoft Windows in enhanced mode.

You are running Microsoft Windows in enhanced mode, but have run out of virtual memory.
Increase virtual memory by freeing some disk space, or at least ensure that some space is available.

You have terminate-and-stay-resident programs running.
Eliminate terminate-and-stay-resident programs.

You have many device drivers loaded.
Eliminate unnecessary device drivers.

You have run out of space for Public variables.
Reduce the number of Public variables.


9 Subscript out of range
10 This array is fixed or temporarily locked
11 Division by zero
13 Type mismatch
14 Out of string space
16 Expression too complex
The number of subexpressions allowed in a floating-point expression varies among platforms. For example, on 32-bit Microsoft Windows operating systems, the limit is 8 levels of nested floating-point expressions. This error has the following cause and solution:

A floating-point expression contains too many nested subexpressions.
Break the expression into as many separate expressions as necessary to prevent the error from occurring.

Note In earlier versions of Visual Basic, Error 16 was "String expression too complex." That error condition can no longer occur. However, if you have early code that traps and handles that error, you should remove it to prevent confusion with this new error.

17 Can't perform requested operation
18 User interrupt occurred
The process of breaking execution is useful, but if left unhandled, it results in termination of the application. This error has the following cause and solution:

A user pressed CTRL+BREAK or another interrupt key.
In the development environment, continue execution. To provide for the occurrence of this condition at run time, handle the error in an appropriate way.
 
20 Resume without error
28 Out of stack space
35 Sub, Function, or Property not defined
47 Too many code resource or DLL application clients
48 Error in loading code resource or DLL
49 Bad code resource or DLL calling convention
51 Internal error
52 Bad file name or number
53 File not found
54 Bad file mode
55 File already open
Sometimes a file must be closed before another Open or other operation can occur. This error has the following causes and solutions:

A sequential-output mode Open statement was executed for a file that is already open.
You must close a file opened for one type of sequential access before opening it for another. For example, you must close a file opened for Input before opening it for Output.

A statement, for example, Kill, SetAttr, or Name, refers to an open file.
Close the file before executing the statement.

57 Device I/O error
58 File already exists
59 Bad record length
61 Disk full
62 Input past end of file
63 Bad record number
67 Too many files
68 Device unavailable
70 Permission denied
71 Disk not ready
74 Can't rename with different drive
75 Path/File access error
76 Path not found
91 Object variable or With block variable not set
92 For loop not initialized
93 Invalid pattern string
94 Invalid use of Null
97 Can't call Friend procedure on an object that is not an instance of the defining class
98 A property or method call cannot include a reference to a private object, either as an argument or as a return value
298 System resource or DLL could not be loaded
320 Can't use character device names in specified file names
321 Invalid file format
322 Can’t create necessary temporary file
325 Invalid format in resource file
327 Data value named not found
328 Illegal parameter; can't write arrays
335 Could not access system registry
336 Component not correctly registered 
337 Component not found
338 Component did not run correctly
360 Object already loaded
361 Can't load or unload this object
363 Control specified not found
364 Object was unloaded
365 Unable to unload within this context
368 The specified file is out of date. This program requires a later version
371 The specified object can't be used as an owner form for Show
380 Invalid property value
381 Invalid property-array index
382 Property Set can't be executed at run time
383 Property Set can't be used with a read-only property
385 Need property-array index
387 Property Set not permitted
393 Property Get can't be executed at run time
394 Property Get can't be executed on write-only property
400 Form already displayed; can't show modally
402 Code must close topmost modal form first
419 Permission to use object denied
422 Property not found
423 Property or method not found
424 Object required
425 Invalid object use
429 Component can't create object or return reference to this object
430 Class doesn't support Automation
432 File name or class name not found during Automation operation
438 Object doesn't support this property or method
440 Automation error
When you access Automation objects, specific types of errors can occur. This error has the following cause and solution:

An error occurred while executing a method or getting or setting a property of an object variable. The error was reported by the application that created the object.
Check the properties of the Err object to determine the source and nature of the error. Also try using the On Error Resume Next statement immediately before the accessing statement, and then check for errors immediately following the accessing statement.

442 Connection to type library or object library for remote process has been lost
443 Automation object doesn't have a default value
445 Object doesn't support this action
446 Object doesn't support named arguments
447 Object doesn't support current locale setting
448 Named argument not found
449 Argument not optional or invalid property assignment
450 Wrong number of arguments or invalid property assignment
451 Object not a collection
452 Invalid ordinal
453 Specified code resource not found
454 Code resource not found
455 Code resource lock error
457 This key is already associated with an element of this collection
458 Variable uses a type not supported in Visual Basic
459 This component doesn't support the set of events
460 Invalid Clipboard format
461 Method or data member not found
462 The remote server machine does not exist or is unavailable
463 Class not registered on local machine
480 Can't create AutoRedraw image
481 Invalid picture
482 Printer error
This error has the following cause and solution:

An error occurred at the printer, but no other information was returned to the computer that sent the file.
You must physically examine the printer. Make sure all connections between computer and printer are solid. Most printers provide a display for error information such as "Out of paper," "Offline," and so on.

483 Printer driver does not support specified property
484 Problem getting printer information from the system. Make sure the printer is set up correctly
485 Invalid picture type
486 Can't print form image to this type of printer
520 Can't empty Clipboard
521 Can't open Clipboard
735 Can't save file to TEMP directory
Components often need to save temporary information to disk. This error has the following cause and solution:

Component can't find a directory named TEMP.
Create a directory named TEMP and set the TEMP environment variable equal to its path.

The drive or partition containing the TEMP directory lacks sufficient space to save information.
Make some space on the drive by erasing unnecessary files, or create a TEMP directory on another partition and set the TEMP environment variable equal to its path.

744 Search text not found
746 Replacements too long
31001 Out of memory
31004 No object
31018 Class is not set
31027 Unable to activate object
31032 Unable to create embedded object
31036 Error saving to file
31037 Error loading from file
An error occurred while attempting to read the specified file (set Action = 12). Possible causes:

The FileNumber property is invalid.

The file wasn't opened in Binary mode.

The file wasn't saved properly (set Action = 11).

The file is corrupted.

The file position isn't located at the beginning of a valid OLE object.

Why not try one of the articles at our website

Add a Global Error Handler To Your Page
Tuning Up Your Design Toolbars In Access 2000/97
Make The Office Balloon Object Work For Your (Access) Application

Click on the button for the next page in this Access Loop.

Links >>>  Home | Search | Workbench | Orders | Newsletter | Access Security | Access professionals