Re: List of DAO error codes

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jim Carlock (anonymous_at_127.0.0.1)
Date: 04/06/04 

Date: Tue, 6 Apr 2004 12:41:21 -0400

Dale,

You can use some VBA code I think such as:

Dim ErrType As DAO.Error
Dim sErrMsg As String
For Each errType in DAO.Errors
  sErrMsg = sErrMsg & "Error Number: " & errType.Number & " " &
errType.Description & vbCrLf
Next errType

There seem to be three properties for DAO.Error type.

You'll can play around with that on how to throw it into a textbox
or richtextbox, or you can throw the information into a data table. 

-- 
Jim Carlock
http://www.microcosmotalk.com/
Post replies to the newsgroup.
"Dale" <dale0610@hotmail.com> wrote in message
news:uo8ggB$GEHA.3880@TK2MSFTNGP10.phx.gbl...
Thanks for your help Jim.  I don't have Visual C++ but I'll go with your
other suggestions.
Jim Carlock wrote:
> I don't know if these are correct or where they got them from, but there
> do seem to be references here and there that there are files that come
> with Visual C++, ( dbdaoerr.h ?? ).
>
> http://www.vb123.com/toolshed/01_bugs/access_errors.htm
>
> Also, you can use the Err.Number, Err.Description to trap the errors
> and get the friendly help information for each error number.
>
> Use
>
> Private Sub subProblemSub()
> On Error Goto LocalErr
>   '...doing stuff
>   Exit Sub
> LocalErr:
>   MsgBox "Error # " & CStr(Err.Number) & vbCrLf & Err.Description
>   Err.Clear
> End Sub
>
> Hope that helps.
>

Relevant Pages

  • Re: DAO.Errors
    ... "Jim Carlock" wrote in message ... > Private Function ErrCount() As Long ... > Dim ErrType As DAO.Error, ... > Post replies to the newsgroup. ...
    (microsoft.public.vb.general.discussion)
  • Re: List of DAO error codes
    ... > Dim ErrType As DAO.Error ... > Dim sErrMsg As String ... > For Each errType in DAO.Errors ...
    (microsoft.public.vb.database.dao)