Access Error Method Example
Access Error Method - You can use the Access Error method
to return the description associated with a Microsoft Access or DAO error when
the error hasn't actually occurred.
However, you can't use the Access Error
method for ADO errors in Visual Basic.
Application Object AccessError method Visual Basic example:
Function ErrorString(ByVal lngError As Long) As String
' begin Access Error method code
Const conAppError = "Application-defined or " & _
On Error Resume Next
If Err.Description = conAppError Then
ErrorString = AccessError(lngError)
ElseIf Err.Description = vbNullString Then
MsgBox "No error string associated with this error."
ErrorString = Err.Description
' end Access Error method code
Our programming team has 15 members containing a wide variety of technical database knowledge and programming experience. Experts in small business management and scientific database programming.
Did you know you don't need to move to SQL/Server to run and manage your Access database on the net. There are many alternative solutions. Among them are Amazon's AWS cloud services and various hosting services in nearly every state.
You should use VBA error handling code in all of you VBA
modules, subroutines and functions. If you use global variables and you do
not have error handling in all subroutines then you will lose the values in your
global variables when an unhandled error condition happens.