Home  Fees/Services  Access Examples  Tutorials  Access Download  Articles  Search  Contact  Privacy  Links
Application Object Examples
Access Error Method

Visual Basic Application Objects

 





Access Error
AddToFavorites
BuildCriteria
CloseCurrentDatabase
CodeDB
CompactRepair
ConvertAccessProject


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 " & _
"object-defined error"

On Error Resume Next
Err.Raise lngError

If Err.Description = conAppError Then
    ErrorString = AccessError(lngError)
ElseIf Err.Description = vbNullString Then
    MsgBox "No error string associated with this error."
Else
    ErrorString = Err.Description
End If

' end Access Error method code

End Function



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.








A Blue Claw Database Design Article:

ODBC Links To Other DB Systems
 





Blue Claw Database Design Downloadable Tutorial:
How To Fill Fields From Combo Box  





A Blue Claw Software Design Template:

Lease Contract Admin Software
 



Contact Information

Copyright 2000-2017 Blue Claw Database Design