Re: List of DAO error codes

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

From: Dale (dale0610_at_hotmail.com)
Date: 04/06/04

  • Next message: Jim Carlock: "Re: List of DAO error codes" 
    Date: Tue, 06 Apr 2004 09:01:56 -0700

    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.
    >

  • Next message: Jim Carlock: "Re: List of DAO error codes"

    Relevant Pages

    • Re: Memory Leak - Jet4.0v4.0.8015.0, XP, ADO2.7, DAO3.6
      ... opening a database, then a recordset, closing the recordset then the ... available physical memory drop with Windows Task Manager. ... Sub DAOOpenJetDatabase() ... On Error GoTo localErr ...
      (microsoft.public.vb.database)
    • Re: Memory Leak - Jet4.0v4.0.8015.0, XP, ADO2.7, DAO3.6
      ... > available physical memory drop with Windows Task Manager. ... > Sub DAOOpenJetDatabase() ... > Dim PeopleTable As DAO.Recordset ... > On Error GoTo localErr ...
      (microsoft.public.vb.database)
    • Re: cmdFind_Click
      ... Private Sub FillCustomer() ... Private Sub cbo1_Click ... > On Error GoTo LocalErr ... >> It's a command button, ...
      (microsoft.public.vb.general.discussion)
    • Re: Memory Leak - Jet4.0v4.0.8015.0, XP, ADO2.7, DAO3.6
      ... > Sub DAOOpenJetDatabase() ... > Dim PeopleTable As DAO.Recordset ... > On Error GoTo localErr ... > Dim cnn As New ADODB.Connection ...
      (microsoft.public.vb.database)
    • Re: cmdFind_Click
      ... Private Sub Combo1_Click ... On Error GoTo LocalErr ... Private Sub Command1_Click ... > It's a command button, ...
      (microsoft.public.vb.general.discussion)